Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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,
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 |
Thank you very much, it works
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!
Count the number of repitation by group Final ID, Rank will gives me wrong answer
Any other suggestion pls
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |