Forum Discussion
Solved
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? I ha...
Try wrapping 'Actions'[StartDate] in lines 15 and 24 with FORMAT using the appropriate format string:
FORMAT ( 'Actions'[StartDate], "dd/mm/yyyy" )
AlexisOlson
Super User
Super UserTry 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!
- AlexisOlson
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.
