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.
Hello,
Could you please help me make a rank col for the following dataset? Namely, the rank 1 should be assigned to the newest app version on each platform no matter the problem field. The rank column should be updated with every new release, so the newest version is always ranked first. Do you have any idea?
thanks
Platform | Version | Problem | Rank |
Android | 8.18 | Message | 1 |
Android | 8.18 | Call | 1 |
Android | 8.18 | Network | 1 |
Android | 8.18 | Video | 1 |
Android | 8.16 | Call | 2 |
Android | 8.16 | Network | 2 |
Android | 8.16 | Video | 2 |
Android | 8.15 | Message | 3 |
Android | 8.15 | Call | 3 |
Android | 8.15 | Network | 3 |
Android | 8.14 | Call | 4 |
iOS | 8.1 | Video | 1 |
iOS | 8.1 | Call | 1 |
iOS | 8.1 | Network | 1 |
iOS | 8.09 | Network | 2 |
iOS | 8.08 | Call | 3 |
iOS | 8.08 | Video | 3 |
iOS | 8.08 | Video | 3 |
iOS | 8.07 | Call | 4 |
Win | 12 | Network | 1 |
Win | 12 | Call | 1 |
Win | 11 | Network | 2 |
Win | 11 | Video | 2 |
Win | 11 | Message | 2 |
Win | 10 | Call | 3 |
Win | 9 | Video | 4 |
Solved! Go to Solution.
HI @Boja
Try this calculated column
RANK_ = RANKX ( FILTER ( Table1, Table1[Platform] = EARLIER ( Table1[Platform] ) ), Table1[Version], , DESC, DENSE )
HI @Boja
Try this calculated column
RANK_ = RANKX ( FILTER ( Table1, Table1[Platform] = EARLIER ( Table1[Platform] ) ), Table1[Version], , DESC, DENSE )
It works perfectly. Thanks Zubair!
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |