Forum Discussion
Conditional Sequence
Hi ,
Need help .I have Part # column in Power bi which has Part # in it.
I want to create the custom column , which checks if the current "Part#" is different from the "Part#" in the previous row. If it is different, it starts a new sequence with 1; otherwise, it continues the sequence by incrementing the previous index.
Please share Pbix. Thanks for helping. Appriciate your effort.
| Sequence | Part# |
| 1 | 3856 |
| 1 | 2345 |
| 2 | 2345 |
| 3 | 2345 |
| 1 | 1234 |
| 2 | 1234 |
4 Replies
HI AnkurSharma ,
Please try following measure to create calculated column
Rankin =
RANKX(FILTER('Table','Table'[Part#] = EARLIER('Table'[Part#])),'Table'[Sequence],,ASC,DENSE)Please find the pbix file - https://www.dropbox.com/scl/fi/2gzgbjyvten706jxe26to/RankPart_31_jan.pbix?rlkey=1dggairjazot060ubjmnhp4a7&dl=0Thanks and Regards,
Sayali
Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!
I want to create this in Transform data so that i can make unique column by combining Part# and sequence,
Hi AnkurSharma ,
Please refer the steps from following article. I tried it and it works
https://www.analytics-tuts.com/ranking-by-groups-using-power-query-in-power-bi/
Thanks and Regards,
Sayali
Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!
