Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power BI Blog: Q&A Improvements for Inferred Results

1 July 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at how Q&A is being improved in the June update of Power BI Desktop.


Power Query: A List of Distinct Possibilities

30 June 2021

Welcome to our Power Query blog. This week, I look at List.Distinct().


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

29 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 ACOSH with no offensive weapon in sight…


Monday Morning Mulling – June 2021

28 June 2021

On the final Friday of each month, we are going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you are...


Final Friday Fix – June 2021

25 June 2021

On the final Friday of each month, we are going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you are...


Power BI Blog: CALENDAR tables

24 June 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at dynamic calendars that we can use for our analysis.


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.


Newsletter