Please note javascript is required for full website functionality.

Blog

Power Pivot Principles: The A to Z of DAX Functions – INFO.DELTATABLEMETADATASTORAGES

6 August 2024

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at INFO.DELTATABLEMETADATASTORAGES.


A to Z of Excel Functions: The DETECTLANGUAGE Function

5 August 2024

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DETECTLANGUAGE function.


Excel for Mac: Modifying Slicer styles

2 August 2024

This week in our series about Microsoft Excel for Mac, we focus on a problem with the dialog for modifying a Slicer style.


Power BI Blog: Funnel Chart – Part 1

1 August 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the Funnel chart.


Power Query: Month Mayhem – Part 5

31 July 2024

Welcome to our Power Query blog. Today, I create mapping queries which I will be using to move the data.


Power Pivot Principles: The A to Z of DAX Functions – INFO.DATASOURCES

30 July 2024

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at INFO.DATASOURCES.


Monday Morning Mulling: July 2024 Challenge

29 July 2024

On the final Friday of each month, we set an Excel problem (or something similar!) for you to puzzle over for the weekend. On the Monday, we publish one suggested solution. No-one is stating this is the best approach, it’s just the one we selected. If you don’t like it, lump it – or contact us with your preferred solution.


Final Friday Fix: July 2024 Challenge

26 July 2024

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Power BI Blog: Power BI Enhanced Report Format (PBIR)

25 July 2024

Welcome back to our Power BI blogs. This time, we look at the enhanced report format for Power BI, PBIR.


Power Query: Month Mayhem – Part 4

24 July 2024

Welcome to our Power Query blog. Today, I use the Source Summary query as a building block, as I continue transforming the data.


Newsletter