Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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?
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.
Solved! Go to Solution.
Try wrapping 'Actions'[StartDate] in lines 15 and 24 with FORMAT using the appropriate format string:
FORMAT ( 'Actions'[StartDate], "dd/mm/yyyy" )
Apologies i think i was flustered and misread your first answer, this has worked now! Thank you 🙂
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
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
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 103 | |
| 80 | |
| 63 | |
| 50 | |
| 45 |