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 […]