Please note javascript is required for full website functionality.

Blog

Power Query: Project Population – Part 11

5 July 2023

Welcome to our Power Query blog. This week, I merge more data from a public source.


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

4 July 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 EARLIER.


Monday Morning Mulling: June 2023 Challenge

3 July 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: June 2023 Challenge

30 June 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: Dynamic Format Strings for Measures

29 June 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the new dynamic format strings for measures.


Power Query: Project Population – Part 10

28 June 2023

Welcome to our Power Query blog. This week, I transform a new query from a public data source.


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

27 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 DURATION.


A to Z of Excel Functions: The PDURATION Function

26 June 2023

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


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

23 June 2023

Welcome back to this week’s Charts and Dashboards blog series. This week, complete our series on the Working Capital Adjustment Chart, by looking at how we create the chart from the data we have calculated.


Power BI Blog: Composite Models on Power BI Datasets and Analysis Services Models

22 June 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we discuss composite models.


Newsletter