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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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