Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Three Sheets to the Table

9 June 2021

Welcome to our Power Query blog. This week, I look at combining sheets where the columns do not match.


Power Pivot Principles: Calculated Field vs. Measure

8 June 2021

Welcome back to the Power Pivot Principles blog. This week, we consider the differences between creating a calculated field and a calculated measure.


A to Z of Excel Functions: the ISNA Function

7 June 2021

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


Charts and Dashboards Blog: A Bar Chart with Dynamic Ordering – Part 2

4 June 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to talk about the bar chart with dynamic ordering.


Power BI Blog: Smart Narratives Now Generally Available

3 June 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we look at Smart Narratives, which are now Generally Available in Power BI Desktop.


Power Query: Evasive Errors

2 June 2021

Welcome to our Power Query blog. This week, I look at a problem I came across when uploading a large dataset from Excel.


Power Pivot Principles: Initial Measures – a Pro Tip

1 June 2021

Welcome back to the Power Pivot Principles blog. This week, we explain the advantages of creating measures from fields. Who’d have thought..?


Monday Morning Mulling: May 2021 Challenge

31 May 2021

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI 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...


A to Z of Excel Functions: the ISLOGICAL Function

31 May 2021

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


Final Friday Fix: May 2021 Challenge

28 May 2021

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


Newsletter