Please note javascript is required for full website functionality.

Blog

Power Query: Join or List - Part 5

28 December 2022

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table with approximate matching using List() functions.


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

27 December 2022

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


Monday Morning Mulling: December 2022 Challenge

26 December 2022

Merry Christmas and Happy New Year! 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: December 2022 Challenge

23 December 2022

Merry Christmas and Happy New Year! 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: Datamarts – Part 5

22 December 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at generating queries using the user interface (UI) available for datamarts.


Power Query: Join or List - Part 4

21 December 2022

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table, this time with approximate matching.


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

20 December 2022

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


A to Z of Excel Functions: The NORM.S.DIST Function

19 December 2022

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


Charts and Dashboards: Vertical Raincloud Chart Part 2

16 December 2022

Welcome back to our Charts and Dashboards blog series. This week, we’re continuing to look at how to make a bespoke Vertical Raincloud chart by creating the second of three charts that we will need.


Power BI Blog: Datamarts – Part 4

15 December 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we will begin exploring the Preview of datamarts in Power BI.


Newsletter