Please note javascript is required for full website functionality.

Blog

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.


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

25 October 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 COUPDAYSNC.


A to Z of Excel Functions: The NEGBINOMDIST Function

24 October 2022

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


Charts and Dashboards: Charting Example – Extended Case Study Part 6

21 October 2022

Welcome back to our Charts and Dashboards blog series. This week, we’re going to continue to look at the example chart and finally cover the workings behind it.


Newsletter