Please note javascript is required for full website functionality.

Blog

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

31 January 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 DATEDIFF.


Monday Morning Mulling: January 2023 Challenge

30 January 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: January 2023 Challenge

27 January 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: Creating Dynamic Slicers using Field Parameters

26 January 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to create dynamic slicers using field parameters.


Power Query: Refreshing Challenges on the Web – Part 1

25 January 2023

Welcome to our Power Query blog. This week, I investigate how to refresh queries in Excel for the Web.


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

24 January 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 DATEADD.


A to Z of Excel Functions: The NORMSDIST Function

23 January 2023

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


Charts and Dashboards: The Risk Bubble Chart – Part 2

20 January 2023

Welcome back to our Charts and Dashboards blog series. This week, we’re going to continue looking at how to make a Risk Bubble chart.


Power BI Blog: Controlling and Customising Labels on Azure Maps

19 January 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at controlling and customising labels on Azure maps.


Power Query: Expendable Expand

18 January 2023

Welcome to our Power Query blog. This week, I investigate how to avoid expanding data after merging.


Newsletter