Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Angel
Resolver III
Resolver III

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.

 

Captura.JPGCaptura.JPG

 

 

Any suggestion??

 

Thanks,

 

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
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.




Lima - Peru

View solution in original post

2 REPLIES 2
Vvelarde
Community Champion
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.




Lima - Peru

@Vvelarde

 

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

 

You have saved to me lot of time.

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.