On the final Friday of each month, we set an Excel problem (or something similar!) for you to puzzle over for the weekend. On the Monday, we publish one suggested solution. No-one is stating this is the best approach, it’s just the one we selected. If you don’t like it, lump it – or contact us with your preferred solution.

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.

Welcome back to our Power BI blogs. This time, we look at the enhanced report format for Power BI, PBIR.

Welcome to our Power Query blog. Today, I use the Source Summary query as a building block, as I continue transforming the data.

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 INFO.CALCDEPENDENCY.

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

This week in our series about Microsoft Excel for Mac, we discuss PivotCharts, which have a few differences when compared to Excel for Windows.

Welcome back to our Power BI blogs. This time, we look at (yet) another blast of INFO functions.

Welcome to our Power Query blog. Today, I use the Source Data query as a building block as I continue transforming the data.

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 INFO.CULTURES.