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!

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

Welcome to our Power Query blog. This week, I continue my look at some new additions to the View tab, which are still not available on all versions of Power Query. Today, I look at ‘Column Profile’ and ‘Column Quality’.

Welcome back to the Power Pivot Principles blog. This week, let’s discuss the difference between the RELATED and LOOKUPVALUE functions.

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

Welcome back to this week’s Charts and Dashboards blog series. This week, let’s continue to talk about PivotChart.