Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


Power Query: PDF Pandemonium – Part 3

29 September 2021

Welcome to our Power Query blog. This week I continue transforming some data that is coming in from a PDF file.


Power Pivot Principles: The A to Z of DAX Functions - ATANH

28 September 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 all a load of hyperbolics…

 

 


Monday Morning Mulling: September 2021 Challenge

27 September 2021

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to...


A to Z of Excel Functions: the LET Function

27 September 2021

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


Newsletter