Forum Discussion
DATEVALUE function recognising date as mmddyyyy instead of ddmmyyyy
I've looked through this forum and haven't found a response that solves this issue. I have a table from ssms that comes into Power BI as a date (ddmmyyyy) and my locale is also set to UK however, i...
The issue is that date column I'm using is already formatted as ddmmyyyy so i don't need to do anything with that column. The issue arises when i use datevalue
The issue you're encountering is likely due to how DAX handles date literals, which are interpreted in the US date format (mm/dd/yyyy) by default, even if your data and locale are set to UK (dd/mm/yyyy).
