Forum Discussion

MJG2112's avatar
MJG2112
Icon for Advocate II rankAdvocate II
5 months ago
Solved

Date to Text Format Differences - Causing Me a Big Problem

I have a set of reports that create composite keys using a numeric value and date.  It's very basic but serves my needs.   CompositeKey = MyTable[EntityID] & "-" & MyTable[Reporting Month]   Th...
Need Help
Show and Tell
  • MJG2112's avatar
    MJG2112
    5 months ago

    hi mizan2390 that worked with the addition of a locale parameter at the end of the FORMAT:

     

    CompositeKey = MyTable[EntityID] & "-" & FORMAT(MyTable[Reporting Month], "dd/MM/yyyy", "en-GB")

     

mizan2390's avatar
mizan2390
Icon for Super User rankSuper User
5 months ago

hi MJG2112 

The issue you are experiencing is caused by DAX's implicit automatic type conversion when using the & concatenation operator. When you concatenate a date with a string, DAX automatically converts the date into text relying on the local machine's default system settings. 

Can you please try the DAX below and see if this solves your problem.

CompositeKey = MyTable[EntityID] & "-" & FORMAT(MyTable[Reporting Month], "dd/MM/yyyy")

If this solves your problem, please give a kudos and mark this as solved.