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 new dynamic format strings for measures.

Welcome to our Power Query blog. This week, I transform a new query from a public data source.

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

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

Welcome back to this week’s Charts and Dashboards blog series. This week, complete our series on the Working Capital Adjustment Chart, by looking at how we create the chart from the data we have calculated.

Welcome back to this week’s edition of the Power BI blog series. This week, we discuss composite models.

Welcome to our Power Query blog. This week, I continue combining my queries from a public data source.

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

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