Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Pivot Principles: SWITCH with an Expression

29 September 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about using the SWITCH function to return an Expression.


Monday Morning Mulling: September 2020 Challenge

28 September 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...


Final Friday Fix: September 2020 Challenge

25 September 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...


Power BI: Calculating Cumulative Totals for Time Periods

24 September 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau looks at how to calculate cumulative totals for time periods in Power BI.


Power Query: Picky Pivoting

23 September 2020

Welcome to our Power Query blog. This week, I look at unpivoting data with multiple headings.


Power Pivot Principles: Irregular Month-End Reporting Case – Part 6

22 September 2020

Welcome back to the Power Pivot Principles blog. This week, we will look at an alternative way to calculate the All Year Sales in our seemingly never-ending case study.


A to Z of Excel Functions: the IMEXP Function

21 September 2020

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


Charts and Dashboards Blog: Dashboard Workbook Layout – Part 3

18 September 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to talk about the dashboard design.


Power BI Blog: Displaying Multiple Slicer Selections on Cards

17 September 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau looks at how to create a card that displays slicer selections in Power BI.

 

 


Power Query: Tool Tip

16 September 2020

Welcome to our Power Query blog. This week, I look at how to use M metadata functions to create a ToolTip for columns.


Newsletter