Forum Discussion
Need help to rank non numeric data
I have recently stated working on power bi and I'm struggling with this below mentioned scenario. your help will be appreciated 🙂 I wanted to rank some non character data in power bi using a meas...
- You can try this as a calculated COLUMN:
Rank Dax = RANKX(FILTER(ALL('Table'), 'Table'[Product Id] = EARLIER('Table'[Product Id])), 'Table'[type],,ASC)
AllisonKennedy
Community Champion
Community ChampionTo use EARLIER in this context it must be a calculated COLUMN. Not measure.
If you want to use a measure it could possibly be done with the use of variables.
If you want to use a measure it could possibly be done with the use of variables.
It worked :).
Thanks
- AllisonKennedyYou're welcome. Glad it worked 🙂