Forum Discussion
Solved
Formatting Maxdate (no time)
Hi,
When I am using the DAX MaxDate automatically the formatting is MM/DD/YYYY + time. Is it possible to only show the MM/DD/YYYY without time in a card?
Thanks for your help!
Mo_2020 ,
format(Max(Table[Date]) , "MM/DD/YYYY hh:mm:ss")
new column
or if([Date] = max(Table[Date]), "MM/DD/YYYY hh:mm:ss", blank())
2 Replies
Mo_2020 ,
format(Max(Table[Date]) , "MM/DD/YYYY hh:mm:ss")
new column
or if([Date] = max(Table[Date]), "MM/DD/YYYY hh:mm:ss", blank())
Thanks, this worked:)!
--> format(Max(Table[Date]) , "MM/DD/YYYY hh:mm:ss")
