Please note javascript is required for full website functionality.

Blog

Power BI Blog: 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: 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: ToolTip

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.


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

15 September 2020

Welcome back to the Power Pivot Principles blog. This week, we will be considering the penultimate steps in our irregular month-end reporting case study.


A to Z of Excel Functions: The IMDIV Function

14 September 2020

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


Charts and Dashboards: Dashboard Workbook Layout – Part 2

11 September 2020

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


Newsletter