Formatting data in DAX mesaure

[Anonymous]

Hey guys, 

I'm using the following measure:

LastDate = "Up to and including " & LASTDATE('Date'[Date]). 

However, when displayed the date is defaulting to format Month/Day/Year. Despite me defaulting it to dd/mm/yyyy in the data tab. Any suggestion on how I can force the format within the dax measure? 

[vanessafvg]

have you tried using the format function?

https://docs.microsoft.com/en-us/dax/format-function-dax

also which setting isn't working?

[Anonymous · Accepted solution]

actually I've got it 😄 

LastDate = "Up to and including " & FORMAT(LASTDATE('Date'[Date]), "dd/mm/yyyy"). Thanks for your help. 

[Anonymous]

Hi, 

Yeah, I've tried this but I'm getting an error. 

LastDate = "Up to and including " & FORMAT(LASTDATE('Date'[Date]), "dd/mm/yyyy"))