Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Evaluate the Environment

23 June 2021

Welcome to our Power Query blog. This week I look at the importance of environment to Expression.Evaluate().


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

22 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. This week it’s ACOS with no lettuce in sight…


A to Z of Excel Functions: the ISNUMBER Function

21 June 2021

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


Charts and Dashboards: More Target Practice

18 June 2021

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


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.


Newsletter