Forum Discussion
snolan
3 years agoNew Member
Format
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
3 Replies
- Greg_DecklerCommunity Champion
snolan Is your yyyymm column an actual date column or is it a numeric column like 202210?
- snolanNew Memberyyyymm = format(Cancelexport[CALENDAR_MONTH_END_DATE],"mm-yyyy")date column that is formatted
- snolanNew Member
i removed the last ')' and it seemed to fix the issue.