Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power BI Blog: Dynamic Headers

17 June 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at dynamic titles, and how to create titles with multiple linked values.


Power Query: Fixed Expression

16 June 2021

Welcome to our Power Query blog. This week, I look at the M function Expression.Constant().


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

15 June 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. So how about take a brake and read about ABS…


A to Z of Excel Functions: the ISNONTEXT Function

14 June 2021

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


Charts and Dashboards: Target Practice

11 June 2021

Welcome back to our Charts and Dashboards blog series. This week, I look at creating a presentation of actual vs. target sales.


Power BI Blog: Monthly New Customers

10 June 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at how to create a simple measure to count the number of new customers in a database for each month.


Power Query: Three Sheets to the Table

9 June 2021

Welcome to our Power Query blog. This week, I look at combining sheets where the columns do not match.


Power Pivot Principles: Calculated Field vs. Measure

8 June 2021

Welcome back to the Power Pivot Principles blog. This week, we consider the differences between creating a calculated field and a calculated measure.


A to Z of Excel Functions: the ISNA Function

7 June 2021

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


Charts and Dashboards Blog: A Bar Chart with Dynamic Ordering – Part 2

4 June 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to talk about the bar chart with dynamic ordering.


Newsletter