Please note javascript is required for full website functionality.

Blog

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

8 November 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 COUPNUM.


A to Z of Excel Functions: the NETWORKDAYS Function

7 November 2022

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


Charts and Dashboards: Dynamic Arrays in Charts

4 November 2022

Welcome back to our Charts and Dashboards blog series. This week, we’re going to look at how charts interact with dynamic arrays.


Power BI Blog: Row-Level Security (RLS) – Part 1

3 November 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at static row-level security (RLS) in Power BI Desktop.


Power Query: Flexible Appending – Part 1

2 November 2022

Welcome to our Power Query blog. This week, I am combining data from a folder and using a translation table to create column names.


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

1 November 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 COUPNCD.


Monday Morning Mulling: October 2022 Challenge

31 October 2022

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: October 2022 Challenge

28 October 2022

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: Quick Measure Suggestions (an Experimental Feature)

27 October 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at a hot-off-the-press experimental feature to complement Power BI’s Quick Measures.


Power Query: Get Pasted – Part 2

26 October 2022

Welcome to our Power Query blog. This week, after using an alternative approach to a one-off data grab from the web, I transform the data I have pasted.


Newsletter