Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Pivot Principles: Using the ALLNOBLANKROW Function to Calculate The Percentage of Total

13 October 2020

Welcome back to the Power Pivot Principles blog. This week, we consider how to calculate the percentage of a total using the ALLNOBLANKROW.


A to Z of Excel Functions: the IMLOG10 Function

12 October 2020

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


Charts and Dashboards Blog: Sparklines

9 October 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we will consider using sparklines when designing dashboards.


Power BI Blog: Dealing with Overflow on Cards

8 October 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau looks at how to deal with an overflow of slicer selections on card visualisations.


Power Query: Going for the Record

7 October 2020

Welcome to our Power Query blog. This week, I put the spotlight on records.


Power Pivot Principles: Introducing the ALLNOBLANKROW Function

6 October 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about the ALLNOBLANKROW in DAX.


A to Z of Excel Functions: the IMLN Function

5 October 2020

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


Charts and Dashboards Blog: Dashboard Design – Using Tables and Conditional Formatting

2 October 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we will talk about using tables and conditional formatting when designing a dashboard.


Power BI Blog: Ordering Slicer Selections on Cards

1 October 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau looks at how to order slicer selections that are displayed in a card in Power BI.


Power Query: Almost There

30 September 2020

Welcome to our Power Query blog. We turn 200!! To celebrate, I do nothing other than write another article! This week, I look at how to add a fuzzy column.


Newsletter