wynhopkins
Most Valuable Professional
Most Valuable ProfessionalStatus:
New
DATEVALUE returns incorrect date and cannot be avoided on Australian computers
It would appear that Power BI Desktop defaults to a culture of en-US for Australian (and maybe other) users. There appears to be no way to fix this and it will lead to unintended consequences ...
wynhopkinsMost Valuable Professional
Most Valuable ProfessionalHi v-robertq-msft
Yep same issue in latest release. I've asked a number of other people in Australia to test this out and it's a similar issue for them
Using DAX Studio I see that my Culture is en-US. This is where the problem lies I believe.