adding customer column to count the values repetition in ascending order

[ssk_1984]

Hi 

Please help me to the add the count coulm based on the Final ID, How many time the final repetatly appearing with the incresing trend value

For Example here Row 1 to 3, Final ID 12 appeared three times, then values form 1 to 3 added in that column

also for the same Final ID appearing from the row number 6 to 9 , again the values to shown from 1 to 4 as per the repetation

Final ID	SLA Result	Report Date	Count
12	Not Met	01-10-2021	1
12	Not Met	01-11-2021	2
12	Not Met	01-12-2021	3
34	Met	01-12-2021	1
12	Not Met	01-07-2022	1
12	Not Met	01-08-2022	2
12	Not Met	01-09-2022	3
12	Not Met	01-10-2022	4
23	Met	01-07-2022	1
23	Not Met	01-08-2022	2
12	Not Met	01-07-2022	1
12	Not Met	01-08-2022	2
12	Not Met	01-10-2022	1
12	Not Met	01-11-2022	2

[ssk_1984]

I have one more Query, If any of date is skipped in between the Range of Month, It should be recalculated from 1....Here July, Aug then It is again starts from the month Oct, Nov & Dec....Sep is missing...

So 

Final ID	SLA Result	Report Date	Count
12	Not Met	01-10-2021	1
12	Not Met	01-11-2021	2
12	Not Met	01-12-2021	3
12	Not Met	01-07-2022	1
12	Not Met	01-08-2022	2
12	Not Met	01-09-2022	3
12	Not Met	01-10-2022	4
12	Not Met	01-11-2022	5

[ssk_1984]

Thank you very much, it works

[NikhilChenna]

Hi @ssk_1984 , I think its a simple solution. 

You just have to created a new calculated column of Rank using the Rankeq function in Power BI based on the Final ID.

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[ssk_1984]

Count the number of repitation by group Final ID, Rank will gives me wrong answer

Any other suggestion pls 

[NikhilChenna · Accepted solution]

Hi @ssk_1984 ,

Are you looking for the output like this below, 

so you can use the below calculated dax column of Rank usign Rankx,

Rank = RANKX(

FILTER(

'Table (6)',

'Table (6)'[Final ID] = EARLIER('Table (6)'[Final ID])),

'Table (6)'[Report Date], ,ASC,Dense)

I tried this myself , it worked. 

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!