In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at COALESCE.

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI 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.

On the final Friday of each month, we are 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 are playing for bragging rights only!

As you may recall, the new Format pane has been in Preview since last November and was turned on by default for users in February’s Power BI Desktop updates. Now, Microsoft has announced they plan to make this Generally Available in May, which means you will no longer be able to switch back to the old Format pane.

Welcome to our Power Query blog. This week I look again at a query with too many steps.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at BITXOR.

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

Welcome back to our Charts and Dashboards blog series. This week, we consider tornado charts and their uses.

Power BI Goals continues to move forward. This time, we check out the new custom statuses and Teams notifications.

Welcome to our Power Query blog. This week, I look a query with too many steps.