Please note javascript is required for full website functionality.

Blog

Power Query: PDF Pandemonium – Part 5

13 October 2021

Welcome to our Power Query blog. This week, I continue transforming some data that is coming in from a PDF file, turning my attention this week to function development.


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

12 October 2021

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


A to Z of Excel Functions: The LN Function

11 October 2021

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


Charts and Dashboards: Sales Funnel Chart – Part 2

8 October 2021

Welcome back to our Charts and Dashboards blog seriesThis week, I again create a Sales Funnel chart, but this time using Excel’s built-in features.


Power BI Blog: New Formatting Options for Buttons

7 October 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we discuss the new formatting options for buttons in Power BI.


Power Query: PDF Pandemonium – Part 4

6 October 2021

Welcome to our Power Query blog. This week, I continue transforming some data that is coming in from a PDF file, by creating transformations in preparation for developing a function next week.


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

5 October 2021

In our long-established Power Pivot Principles articles, we are starting a new series on the A to Z of Data Analysis eXpression (DAX) functions. This week it’s considered an ordinary function, if not quite AVERAGE…


A to Z of Excel Functions: The LINEST Function

4 October 2021

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


Charts and Dashboards: Sales Funnel Chart – Part 1

1 October 2021

Welcome back to our Charts and Dashboards blog series. This week, I create a Sales Funnel chart.


Power BI Blog: “X” and “Non-X” functions in DAX

30 September 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we discuss the difference between “X” and “Non-X” functions in DAX.


Newsletter