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

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 the DAX function changes to MINX and MAX.

Welcome to our Power Query blog. Today, I look at the ‘Schema tools’ tab in Power Query Online.

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

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

Welcome back to our Charts and Dashboards blog series. This week, we begin to “Mari-make” a Marimekko chart by preparing the data.

Welcome back to this week’s edition of the Power BI blog series. This week, we explain how to have multiple tooltips in one visualisation.

Welcome to our Power Query blog. Today, I merge queries in Power Query Online.