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

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

Welcome back to our Charts and Dashboards blog series. This week, we’re going to continue looking at how to make a bespoke Vertical Raincloud chart by creating the last of three charts that we will need.

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at the options to refresh for datamarts.

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table with approximate matching using List() functions.

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

Merry Christmas and 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.

Merry Christmas and 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.

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at generating queries using the user interface (UI) available for datamarts.

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table, this time with approximate matching.