Please note javascript is required for full website functionality.

Blog

Power Query: Double Access Savings – Part 4

17 August 2022

Welcome to our Power Query blog. This week, I combine the data from the tables in the two Access databases.


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

16 August 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 COT.


A to Z of Excel Functions: The MONTH Function

15 August 2022

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


Charts and Dashboards: A Quick Look at Analysis

12 August 2022

Welcome back to our Charts and Dashboards blog series. This week, I look at the Quick Analysis tool.


Power BI Blog: Composite Models and Dynamic M Query Parameters Part 1

11 August 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we create Dynamic M Query Parameters and reference them in an M query.


Power Query: Double Access Savings – Part 3

10 August 2022

Welcome to our Power Query blog. This week, I continue to extract the data from the tables in the two Access databases.


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

9 August 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 COSH.


A to Z of Excel Functions: The MODE.SNGL Function

8 August 2022

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


Charts and Dashboards: Recommended Charts

5 August 2022

Welcome back to our Charts and Dashboards blog series. This week, we’ll look at Excel’s recommended charts.


Power BI Blog: Metric Visuals Updated

4 August 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at added support for composite models and Dynamic M Query Parameters.


Newsletter