Forum Discussion

tomgag's avatar
tomgag
Resolver I
7 years ago
Solved

DateTime format in Measure

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)

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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