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

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 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 this week’s edition of the Power BI blog series. This week, we look at the Azure Maps visualisation.

Welcome to our Power Query blog. This week, I complete the Project Population series.

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

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

Welcome back to our Charts and Dashboards blog series. This week, we continue to explain how to create a bespoke Point and Figure chart by looking at how we use the summary data to prepare the chart data.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the Optimize tab on the Ribbon.

Welcome to our Power Query blog. This week, I create a query by extracting rows in Data that have no matches in Country.