Please note javascript is required for full website functionality.

Blog

Power BI Blog: Text Data Groups

5 November 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau explores using 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, Jonathan Liau looks 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.


Power Pivot Principles: Working with Averages – Part 1

27 October 2020

Welcome back to the Power Pivot Principles blog. This week, we will discuss working with averages in DAX.


A to Z of Excel Functions: The IMPOWER Function

26 October 2020

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


Charts and Dashboards: Symbol Charts – Part 2

23 October 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to talk about Symbol Charts in dashboards.


Newsletter