topic Re: adding customer column to count the values repetition in ascending order in DAX Commands and Tips

adding customer column to count the values repetition in ascending order

ssk_1984 — Fri, 25 Nov 2022 06:20:05 GMT

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

Re: adding customer column to count the values repetition in ascending order

NikhilChenna — Fri, 25 Nov 2022 07:01:27 GMT

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!

Re: adding customer column to count the values repetition in ascending order

ssk_1984 — Fri, 25 Nov 2022 07:16:24 GMT

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

Any other suggestion pls

Re: adding customer column to count the values repetition in ascending order

NikhilChenna — Fri, 25 Nov 2022 07:37:20 GMT

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!

Re: adding customer column to count the values repetition in ascending order

ssk_1984 — Fri, 25 Nov 2022 08:03:02 GMT

Thank you very much, it works

Re: adding customer column to count the values repetition in ascending order

ssk_1984 — Fri, 25 Nov 2022 09:27:04 GMT

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

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