Please note javascript is required for full website functionality.

Blog

Power Pivot Principles: Getting the Measure of a Measure – Multiple Measure Management

24 November 2020

Welcome back to the Power Pivot Principles blog. This week, we will consider where to store measures when you have many measures and tables in your database.


A to Z of Excel Functions: The IMSEC Function

23 November 2020

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


Charts and Dashboards: Multiple Bullet Charts – Part 2

20 November 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we consider formatting the multiple bullet charts in Excel, created in last week’s blog.


Power BI Blog: Analysing our Bins

19 November 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we dive deep into bins and spout our usual rubbish.


Power Query: Recent Dates

18 November 2020

Welcome to our Power Query blog. This week, I show how to only extract the dataset for the last two years, say.


Power Pivot Principles: Using Measures to Define Target Value in KPIs

17 November 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about using measures to define target values for KPIs.


A to Z of Excel Functions: The IMREAL Function

16 November 2020

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


Charts and Dashboards: Multiple Bullet Charts – Part 1

13 November 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we begin looking at creating multiple bullet charts in Excel.


Power BI Blog: Group Type – Bin (Grouping Numerical Values in Power BI)

12 November 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we explore using the Data Groups functionality in Power BI… again!


Power Query: More Searching Questions

11 November 2020

Welcome to our Power Query blog. This week, I answer some (even) more searching questions.


Newsletter