Forum Discussion

Angel's avatar
Angel
Resolver III
9 years ago
Solved

Format date concatenate

Hi, everyone   I have included a measure in my data model that shows last date refresh have been made.   I would like to show in the report something like: 'Last refresh: dd/mm/aaaa hh_mm:ss.'. ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Angel

     

    hi, you can use this:

     

    LastRefreshText= "Last Refresh " & FORMAT(Max(Table1[LastRefresh]),"DD/MM/YYYY HH: MM : SS")

     

    No Spaces Between Hours Minutes & Seconds.

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Angel

 

hi, you can use this:

 

LastRefreshText= "Last Refresh " & FORMAT(Max(Table1[LastRefresh]),"DD/MM/YYYY HH: MM : SS")

 

No Spaces Between Hours Minutes & Seconds.

Angel's avatar
Angel
Resolver III
9 years ago

Vvelarde

 

Thank you!!!!!!!!!!..

 

You have saved to me lot of time.