Happy New Year! 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. The special challenge this month was to spill a range of cells that vertically appends two input arrays. Easy, yes?

2022 is coming… This is a special challenge of Final Friday Fix series. Hope you enjoy it while celebrating the New Year with your family, friends and colleagues!

Welcome back to this week’s edition of the Power BI blog series. This week, we look at QR Codes with URL Parameters for Power BI Mobile

Welcome to our Power Query blog. This week, I add the parameters I created last week to the query from the week before.

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 CHISQ.DIST function.

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

Welcome back to our Charts and Dashboards blog series. This week, I look at Venn Diagrams.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at Scorecards and Power BI Goals.

Welcome to our Power Query blog. This week, I create parameters for last week’s example.

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 the CEILING...