Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Faulty Filtering

7 July 2021

Welcome to our Power Query blog. This week, I look at an issue with filtering.


Power Pivot Principles: The A to Z of DAX - ACOT

6 July 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 ACOT without a baby…


A to Z of Excel Functions: the ISO.CEILING Function

5 July 2021

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


Charts and Dashboards: Marking Milestones - Part 1

2 July 2021

Welcome back to our Charts and Dashboards blog series. This week, I look at how to plot milestones on a timeline.


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.


Newsletter