DateTime format in Measure

[tomgag]

Hi All,

I have a table for the time and date when my report is last refreshed. However the Lastrefreshed is shown in US data format and I need dd/mm/yyyy

Codes are as below:

Get Date = NOW()

LastRefreshed = "Last Refreshed :" & MAX(DateTime[Get Date]) + (0/24)

[Anonymous · Accepted solution]

@tomgag,

Change your measure to the following:

LastRefreshed = "Last Refreshed :" & FORMAT((MAX(DateTime[Get Date]) + (0/24)),"dd/mm/yyyy hh:mm:ss")

Regards,
Lydia