Forum Discussion

Mo_2020's avatar
Mo_2020
New Member
4 years ago
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! 
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    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())

amitchandak's avatar
amitchandak
Super User
4 years ago

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())