Please note javascript is required for full website functionality.

Blog

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 Principles: 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 IFS Function

8 June 2020

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


Charts and Dashboards: 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.


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


Challenges: 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.


A to Z of Excel Functions: The IFNA Function

1 June 2020

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


Newsletter