Conditional Sequence

[AnkurSharma]

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

[ThxAlot · Accepted solution]

[sayaliredij]

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!! 

[sayaliredij]

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=1dggairjazot060ubjmn...

Thanks and Regards,

Sayali

Please mark the question solved when done and consider giving a thumbs up if posts are helpful!! 

[AnkurSharma]

I want to create this in Transform data so that i can make unique  column by combining Part# and sequence,