Please note javascript is required for full website functionality.

Blog

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.


Charts and Dashboards: Presentation Pitfalls Part 1

4 February 2022

Welcome back to our Charts and Dashboards blog series. This week, I look at what can happen when the chart is inappropriate for the data.


Power BI Blog: Dating Part 5

3 February 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we create a month name column and add it to the hierarchy for Calendar1.


Power Query: Riveting Results Part 8

2 February 2022

Welcome to our Power Query blog. This week, I create a parameter to define the location of another Excel source file.


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

1 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 CLOSINGBALANCEQUARTER.


Newsletter