Wrong date format in a card

[Anonymous]

I have a "last date uppdated" in my dashboard in a Card.

This is how the date gets in to my data:

[Last updated ] = "Last updated: " & FIRSTDATE('Last Refresh'[Date])

Ive tried to change format in the cell of the date and so on but nothing works.

My card is choosing a long AM-PM american way of showing my date from a excel source.
How do i get it to a YYY.MM.DD 13:00 time format?

[jsaunders_zero9]

Try formatting the date using FORMAT()

LastUpdated = "Last Updated: " & FORMAT(FIRSTDATE('Table'[Date]), "YYYY.MM.DD hh:mm")

[jsaunders_zero9]

Full list of formatting options is here

FORMAT function (DAX) - DAX | Microsoft Docs

[Anonymous]

I just cant solve where to put that code in my code.
[Last updated ] = "Last updated: " & FIRSTDATE('Last Refresh'[Date])

[jsaunders_zero9 · Accepted solution]

Hi @Anonymous 

You want to wrap the FORMAT around the FIRSTDATE function

[Last updated ] = "Last updated: " & FORMAT(FIRSTDATE('Last Refresh'[Date]), "YYYY.MM.DD hh:mm")

[Anonymous]

Edit//
Oh now i saw it, hh mm, doh, big thanks!
----------------------
Thanks mate, i got it to work (sorry for the basic questions but im not use to it yet 🙂

[Senast uppdaterad ] = "Senast uppdaterad: " & Format(FIRSTDATE ('Last Refresh'[Datum]),"mm/dd/yyyy", "en-gb" )

But now i dont get time? Only date.

Trying to se why on the page you linked to. but i dont really see why

[Anonymous]

Thanks, ill try to get it to work in my code then. Not use to Dax 🙂