Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Space for a CamelCase

25 November 2020

Welcome to our Power Query blog. This week, I look at how to automate inserting spaces into CamelCase headings.


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 Blog: 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, Jonathan Liau dives deep into bins and spouts his 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 Blog: 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, Jonathan Liau explores using the Data Groups functionality in Power BI… again!


Newsletter