Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Formatting data in DAX mesaure

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? 
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    actually I've got it 😄 

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

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      actually I've got it 😄 

      LastDate = "Up to and including " & FORMAT(LASTDATE('Date'[Date]), "dd/mm/yyyy"). Thanks for your help. 
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, 

       

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

       

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