Please note javascript is required for full website functionality.

Blog

Charts and Dashboards: Presentation Pitfalls Part 3

18 February 2022

Welcome back to our Charts and Dashboards blog series. This week, I look at more pitfalls when using Charts with multiple axes.


Power BI Blog: Roles with no Insight

17 February 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at an issue which can occur when publishing a dashboard.


Power Query: Riveting Results Part 10

16 February 2022

Welcome to our Power Query blog. This week, I show how the FilePath Parameter allows me to change the workbook I extract data from.


Power Pivot Principles: The A to Z of DAX Functions – ACCRINT

15 February 2022

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at ACCRINT.


A to Z of Excel Functions: The MDURATION Function

14 February 2022

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


Charts and Dashboards: Presentation Pitfalls Part 2

11 February 2022

Welcome back to our Charts and Dashboards blog series. This week, I look at one of the pitfalls when using charts with multiple axes.


Power BI Blog: Dating Part 6

10 February 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we continue formatting the Matrix using the amended hierarchy for Calendar1.


Power Query: Riveting Results Part 9

9 February 2022

Welcome to our Power Query blog. This week, I create parameters from another Excel file.


Power Pivot Principles: The A to Z of DAX Functions – CLOSINGBALANCEYEAR

8 February 2022

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at CLOSINGBALANCEYEAR.


A to Z of Excel Functions: The MDETERM Function

7 February 2022

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


Newsletter