Please note javascript is required for full website functionality.

Blog

Power Pivot Principles: Introduction to Key Performance Indicators (KPIs) in Power Pivot

10 November 2020

Welcome back to the Power Pivot Principles blog. So far, we have discussed only about using measures in Power Pivot. This week, we will move away from measures and talk about Key Performance Indicators (KPIs).


A to Z of Excel Functions: The IMPRODUCT Function

9 November 2020

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


Charts and Dashboards: Linking Excel Charts to Power Point

6 November 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we will consider how to link charts from Excel to a presentation in Power Point.


Power BI Blog: Text Data Groups

5 November 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the Data Groups functionality in Power BI.


Power Query: Searching Questions

4 November 2020

Welcome to our Power Query blog. This week, I answer some searching questions.


Power Pivot Principles: Working with Averages – Part 2

3 November 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about using the AVERAGEX function when working with averages in DAX.


Monday Morning Mulling: October 2020 Challenge

2 November 2020

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 2020 Challenge

30 October 2020

On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you’re playing for bragging rights only!


Power BI Blog: Dynamically Calculating Cumulative Metrics with the ALLSELECTED Function

29 October 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to calculate cumulative totals based on a selection on data.


Power Query: Expand Your Calendar

28 October 2020

Welcome to our Power Query blog. This week, I finish my calendar creation.


Newsletter