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 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
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |