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 Source Data query as a building block once more, 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.

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