Measure which returns dates not number ( filter a date column )

[yanisyes]

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,

[amitchandak]

@yanisyes ,

bal date =

maxx(filter(Table, [Name] ="bal"), Table[date])

disco date =

maxx(filter(Table, [Name] ="disco"), Table[date])

[yanisyes · Accepted solution]

Thank you so much