Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Pivot Principle: Introducing the RELATEDTABLE function

2 June 2020

Welcome back to the Power Pivot Principles blog. This week, we consider the RELATEDTABLE function in DAX.

 

 


Monday Morning Mulling: May 2020 Challenge

1 June 2020

On the final Friday of each month, we set an Excel problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Final Friday Fix: May 2020 Challenge

29 May 2020

On the final Friday of each month, we’re 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’re...


Power BI Blog: Custom Visualizations – Funnel/Pyramid Chart

28 May 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau takes a look at new custom visualisation, the Funnel Chart by xViz.


Power Query: More Room for a View

27 May 2020

Welcome to our Power Query blog. This week, I continue my look at some new additions to the View tab, which are still not available on all versions of Power Query. Today, I look at ‘Column Profile’ and ‘Column Quality’.


Power Pivot Principle: 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 Blog: 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.


Newsletter