Please note javascript is required for full website functionality.
MVP

Blog

Blog

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 Blog: 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.


Power BI Blog: Summarising the Top N Number of Cities in a Dataset

10 September 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau looks at how to parameterise the summarisation of the top number of Cities in a dataset.


Power Query: Mad Max Too

9 September 2020

Welcome to our Power Query blog. This week, I look at how to get the maximum example I used last week in just one step.

 

 


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

8 September 2020

Welcome back to the Power Pivot Principles blog. This week, we still continue with our irregular month-end reporting case study.


A to Z of Excel Functions: the IMCSCH Function

7 September 2020

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


Charts and Dashboards Blog: Dashboard Workbook Layout – Part 1

4 September 2020

Welcome back to this week’s Charts and Dashboards blog series. Over the next few weeks, we will talk about how to layout a dashboard. This week, we will consider the workbook layout in general.


Power BI Blog: Creating Custom Hierarchies

3 September 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau looks at how to create custom hierarchies.


Power Query: Mad Max

2 September 2020

Welcome to our Power Query blog. This week, I look at an example of how to work with maximum values.

 

 


Newsletter