Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Pivot Principles: DISTINCT vs. DISTINCTCOUNT

16 June 2020

Welcome back to the Power Pivot Principles blog. This week, we will consider the differences between the DISTINCT and DISTINCTCOUNT functions in DAX.


A to Z of Excel Functions: the IFS Function

15 June 2020

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


Charts and Dashboards Blog: Hiding Data - Part 1

12 June 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, let’s talk about how we can hide one or more data points in a chart.


Power BI Blog – Conditionally Formatting Negative Numbers

11 June 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau takes a look at how to apply conditional formatting to negative numbers.


Power Query: Missing in Transformation

10 June 2020

Welcome to our Power Query blog. This week, I look at a method to make column transformations more dynamic.


Power Pivot Principle: Introducing the DISTINCT function

9 June 2020

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


A to Z of Excel Functions: the IFNA Function

8 June 2020

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


Charts and Dashboards Blog: Highlighting Data

5 June 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, let’s talk about how we can highlight one or more data points in a chart.


Power BI Blog – Custom Visualizations; Funnel/Pyramid Chart Formatting

4 June 2020

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


Power Query: Previous Value

3 June 2020

Welcome to our Power Query blog. Today, I am looking at two ways to reference a previous value in a column.


Newsletter