Rankx for highest difference between MIN()/MAX()

[RMDNA]

Hi all,

I'm trying to rank items by their volatility (highest difference in min and max price) per a period of time.

For example, the overall volatility of the SKU below (in this particular time range) should be 8% (difference between 5 and 13). Then I'd like to rank all SKUs by their volatility, and have that rank change as time is adjusted.

Any assistance? Thanks!

[v-cherch-msft · Accepted solution]

Hi @RMDNA 

You may create a measure like below.If it is not your case,please share some sample data and expected output. It would be helpful to provide an accurate solution.You can also upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Measure  =
RANKX ( ALLSELECTED ( Table), [Sales RM Pct],, ASC )

Regards,