Please note javascript is required for full website functionality.

Blog

Charts and Dashboards: Working Capital Adjustment Chart in Detail – Part 2

9 June 2023

Welcome back to this week’s Charts and Dashboards blog series. This week, we continue to explain how to create a Working Capital Adjustment Chart by looking at how we use the inputs to create the chart data.


Power BI Blog: New Styling for the Format Pane

8 June 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look yet more changes to the look of Power BI.


Power Query: Project Population – Part 7

7 June 2023

Welcome to our Power Query blog. This week, I continue to prepare my second query from a public data source.


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

6 June 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 DIVIDE.


A to Z of Excel Functions: The ODDLYIELD Function

5 June 2023

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


Charts and Dashboards: Working Capital Adjustment Chart in Detail – Part 1

2 June 2023

Welcome back to this week’s Charts and Dashboards blog series. This week, we start to explain how to create a Working Capital Adjustment Chart by looking at how we manage the input data.


Power BI Blog: Email Subscriptions

1 June 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at email subscriptions.


Power Query: Project Population – Part 6

31 May 2023

Welcome to our Power Query blog. This week, I prepare my second query from a public data source.


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

30 May 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 DISTINCTCOUNTNOBLANK.


Monday Morning Mulling: May 2023 Challenge

29 May 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.


Newsletter