Forum Discussion
Helper IIPowerBi ranking changing values over date ranges
Hi,
I am quite new to PowerBi and have a task that I have tried many ways but can’t get the result I need.
The test values are here, the real values have 3000 lines per day instead of in this example where there are three.
I created these test values so that there would be changes in used and therefore available. So that when the formulas/measures work that would be easy to see, instead of 0.00 values.
The task is to, for the values that exist, to have a way to bring to the top (in a table maybe) those values that are increasing in used the most over the last week, month, 3 months, quarter, 6 months. Some may not change this week or month. The same row
might have increased a lot 3 months ago. So top 10 ,20, 50 for those date points in time in the past.
The data is collected once each week only. Which may be part of the problems I have.
8 Replies
- Greg_Deckler
Community Champion
dmcn_pbi Please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
This article may or may not help: https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/td-p/1042520
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2. - amitchandak
Super User
dmcn_pbi ,For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415https://community.powerbi.com/t5/Desktop/RANKX-excluding-blanks/m-p/397656#M181491
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/ - v-diye-msft
Community Support
Hi dmcn_pbi
If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!
