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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
AmberGardner
Frequent Visitor

Date format in Concatenatex Measure

I am currently using a quick measure and it has pulled through the data i need but it has changed the format of the date to MM/DD/YYYY whereas i need it to be DD/MM/YYYY. Can anyone help?

AmberGardner_0-1699888183620.png

I have searched through the possible solutions and i cant seem to get anything to work. I have also looked in these forums and any codes provided so far have caused the measure to break. 

 

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

Try wrapping 'Actions'[StartDate] in lines 15 and 24 with FORMAT using the appropriate format string:

FORMAT ( 'Actions'[StartDate], "dd/mm/yyyy" )

View solution in original post

6 REPLIES 6
AmberGardner
Frequent Visitor

Apologies i think i was flustered and misread your first answer, this has worked now! Thank you 🙂

Ahmedx
Super User
Super User

pls try
new measure = FORMAT([List of StartDate values], "dd/MM/YYYY")

Unfortunately this appears to have kept the date the same, thank you for your support though

AlexisOlson
Super User
Super User

Try wrapping 'Actions'[StartDate] in lines 15 and 24 with FORMAT using the appropriate format string:

FORMAT ( 'Actions'[StartDate], "dd/mm/yyyy" )

This appears to have broken the measure and isnt accepting the dd/mm/yyyy on there

AmberGardner_0-1699893217902.png

Thank you for your help though!

 

You're missing a comma at the end of that line. You've also changed line 27. I don't recommend formatting the sorting arguments in lines 17 and 27, just lines 15 and 24.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors