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.'.

 

I have tried to do that creating a measure:  'Last_Refresh_Concat = CONCATENATE("Last Refresh: ";[Last_Refresh_NoConcat])'

 

I have created another measure to test: 'Last_Refresh_NoConcat = MAX('Sales'[Last refresh column])' 

 

As you can see below, I can format date with no_concat measure, but I don't know how can I do it with concat_measure.

 

 

 

Any suggestion??

 

Thanks,

 

  • 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.

2 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion

    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

      Vvelarde

       

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

       

      You have saved to me lot of time.