We hope you’re having a great Christmas break! 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 following 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, but we do appreciate your enthusiasm!

Welcome back to this week’s edition of the Power BI blog series. This week, we review whether Microsoft should make up words such as “de-duplication”. Or maybe that isn’t what this article is about – perhaps it’s about preventing duplication for composite models on Power BI Datasets and Analysis Services.

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I look at why the method I used required Power Query in Power BI.

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 FLOOR.

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

This week, in our series about Microsoft Excel for Mac, we’ll show you some important PivotTable options that don’t show up in the Field Settings dialog on Mac, even though they are available on Windows, and we’ll show how to work around that limitation.

Welcome back to this week’s edition of the Power BI blog series. This week, we look in more detail at the new DAX query view feature in Power BI Desktop.

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I improve the query to extract data from all pages by extracting the last page number from 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 FIXED.

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