Function Return Types in Power Query

This blog is about function return types in Power Query in Power BI. This article may be more technical than our others but it’s a good read for Power Query enthusiasts or people wanting to make their M code bulletproof. Have you ever modified a column with a function in Power Query where that column […]
Analysing Customer Sales by RANKX() and “What If” Parameters

This post aims to show how to use a combination of the RANKX() function and the Power BI “What-If” parameters to analyse monthly sales to find out which customer has the highest, lowest, and average sales/spending growth. The formula used to calculate the sales trend is: the margin of the current month sales to the […]