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

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

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

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.

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

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

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

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.

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

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 playing for bragging rights only!