Please note javascript is required for full website functionality.

Blog

Power Pivot Principles: The A to Z of DAX Functions – EXCEPT

3 October 2023

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 EXCEPT.


Monday Morning Mulling: September 2023 Challenge

2 October 2023

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.


Final Friday Fix: September 2023 Challenge

29 September 2023

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: DAX Function Changes to MINX and MAXX

28 September 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look the DAX function changes to MINX and MAX.


Power Query: Power Query Online – Part 8

27 September 2023

Welcome to our Power Query blog. Today, I look at the ‘Schema tools’ tab in Power Query Online.


Power Pivot Principles: The A to Z of DAX Functions – EXACT

26 September 2023

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 EXACT.


A to Z of Excel Functions: The PHI Function

25 September 2023

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


Charts and Dashboards: The Marimekko Chart – Part 1

22 September 2023

Welcome back to our Charts and Dashboards blog series. This week, we begin to “Mari-make” a Marimekko chart by preparing the data.


Power BI Blog: Multiple Tooltips in one Visual

21 September 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we explain how to have multiple tooltips in one visualisation.


Power Query: Power Query Online – Part 7

20 September 2023

Welcome to our Power Query blog. Today, I merge queries in Power Query Online.


Newsletter