Forum Discussion
Solved
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 ro...
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=0
Thanks 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,
