Dax support

vjnvinod 

Date(Year([Event Date]),Month([Event Date]),1) 

This is calculating the first day of the month of the EventDate in date format. For example, if the EventDate is 12-Jun-2019, then this formula is converting it to 1-Jun-2019

Date(Year(Today()),Month(Today()),1)

This formula is checking today's date and then calculating the first day of the month (same as logic above)

So essentially I am first converting the EventDate and Today's date to first of the month and then applied the condition you had mentioned.

FORMAT([Event Date],"MMM-YYYY"

This formula is converting the date into the required format.

Hope this answers your query.

Thanks,

Vivek

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.