Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have a tab which summarize the attendance of people in an event per dates
What I want is to create two measure one which return the dates where the people have attended the bal and another one which return only the dates where the people have attended the disco.
If it was number I would only have used the calcultate function but since it's dates I dont know how to do.
THanks in advance for your help.
Best regards,
Solved! Go to Solution.
bal date =
maxx(filter(Table, [Name] ="bal"), Table[date])
disco date =
maxx(filter(Table, [Name] ="disco"), Table[date])
Thank you so much
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |