Please note javascript is required for full website functionality.

Blog

Power Pivot Principles: RELATED vs LOOKUPVALUE

26 May 2020

Welcome back to the Power Pivot Principles blog. This week, let’s discuss the difference between the RELATED and LOOKUPVALUE functions.


A to Z of Excel Functions: The IFERROR Function

25 May 2020

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


Charts and Dashboards: PivotChart – Part 2: Interactivity

22 May 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, let’s continue to talk about PivotChart.


Power BI Blog: Hierarchical Filters

21 May 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau takes a look a new Preview feature in Power BI, Hierarchical Filters.


Power Query: Room for a View

20 May 2020

Welcome to our Power Query blog. This week, I take a look at some new additions to the view tab, which are still not available on all versions of Power Query. I begin with Column Distribution.


Power Pivot Principles: Is there anything RELATED?

19 May 2020

Welcome back to the Power Pivot Principles blog. This week, let’s talk about the RELATED function.


Charts and Dashboards: PivotChart – Part 1: Creating a PivotChart

15 May 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, let’s talk about PivotChart.


A to Z of Excel Functions: The HYPGEOMDIST Function

15 May 2020

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


Power BI Blog: Personalize Visuals (Preview)

14 May 2020

This week we look at a new Preview Feature: Personalize Visuals!


Power Query: Top Two

13 May 2020

Welcome to our Power Query blog. This week, I look at splitting my data into the top two (for example) and the rest.


Newsletter