Forum Discussion
Count of Occurrences
Hey...
I have a table as shown below:
Note:
Highlighted red is for repeated ID's.
So basically what I want to achieve is:
1. How many New ID for a particular month, let say in March, there are 7 new ID (colored blue without red cell in left)
2. How many ID that repeated for a particular month, let say in March, there are 2 repeated ID (colored blue with red cell in left)
3. How many ID that stop repeated for a particular month, let say in March there is only 7 ID that not occurring anymore (the id that appears in February but nor appearing anymore in March)
do you guys have any solution for me?
thank you very much
Hey Anonymous ,
I guess this can easily be adapted to your data model: https://community.powerbi.com/t5/Desktop/NEW-CUSTOMER-AND-REPEATED-CUSTOMER-IN-POWERBI/td-p/457157
Regards,
Tom
2 Replies
- TomMartens
Super User
Hey Anonymous ,
I guess this can easily be adapted to your data model: https://community.powerbi.com/t5/Desktop/NEW-CUSTOMER-AND-REPEATED-CUSTOMER-IN-POWERBI/td-p/457157
Regards,
Tom
- AnonymousNot applicable
it works, thank you TomMartens