Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |