Format

[snolan]

i created a date measure..

to_date = format(MIN(Cancelexport[yyyymm]),"MMM YYYY" & " to " & format(Max(Cancelexport[yyyymm]),"MMM YYYY"))

when i add that to a card, the format looks like this.  (the max month should display Dec 2022).. Help!!

thanks

[snolan]

i removed the last ')' and it seemed to fix the issue.

[Greg_Deckler]

@snolan Is your yyyymm column an actual date column or is it a numeric column like 202210?

[snolan]

yyyymm = format(Cancelexport[CALENDAR_MONTH_END_DATE],"mm-yyyy")

date column that is formatted