Please note javascript is required for full website functionality.

Blog

Power BI Blog: New Way to Upload Power BI and Excel Files

9 February 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at a new way to upload Power BI and Excel files.


Power Query: Web Grouping

8 February 2023

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


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

7 February 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 DATESBETWEEN.


A to Z of Excel Functions: The NORMSINV Function

6 February 2023

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


Charts and Dashboards: The Risk Bubble Chart – Part 3

3 February 2023

Welcome back to our Charts and Dashboards blog series. This week, we move into Week 3 of looking at how to make a Risk Bubble chart.


Power BI Blog: Linked Metrics

2 February 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we consider linked metrics.


Power Query: Refreshing Challenges on the Web – Part 2

1 February 2023

Welcome to our Power Query blog. This week, I continue investigating refreshing queries in Excel for the Web by looking at an example with a query and a PivotTable.


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.


Newsletter