Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Selective Staffing Part 4

17 November 2021

Welcome to our Power Query blog. This week, I revisit my first inclusion examples to find solutions that involve exclusion.


Power Pivot Principles: The A to Z of DAX Functions – CALCULATE

16 November 2021

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at one of the key functions in DAX: CALCULATE.


A to Z of Excel Functions: the LOGNORM.INV Function

15 November 2021

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


Charts and Dashboards: Sparkling Sparklines Part 1

12 November 2021

Welcome back to our Charts and Dashboards blog series. This week, I return to Sparklines.


Power BI Blog: Dating Part 1

11 November 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we look at Auto Date/Time.


Power Query: Selective Staffing Part 3

10 November 2021

Welcome to our Power Query blog. This week, I continue transforming data for a solution that involves including values.


Power Pivot Principles: The A to Z of DAX Functions – BLANK

9 November 2021

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week our functions draw a BLANK…

 

 


A to Z of Excel Functions: the LOGNORM.DIST Function

8 November 2021

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


Charts and Dashboards: Thermometer Chart Part 2

5 November 2021

Welcome back to our Charts and Dashboards blog series. This week, I finish creating a Thermometer chart.


Power BI Blog: Conference Planning Part 2

4 November 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we finish reorganising some data from a table with a single column and create some visualisations.


Newsletter