Forum Discussion

Kees's avatar
Kees
Icon for Helper I rankHelper I
1 year ago

Weird behaviour date field

Hi   I'm struggling with the following, 12 sep date in Data file (XLSX)   Is presented on the desktop correct like:   but on the App is shows lile   Both using the same data...
Need Help
zenisekd's avatar
zenisekd
Icon for Super User rankSuper User
1 year ago

Hi this has something to do with the column format locale. On one instance it takes 09/12/2024 as MM/DD/YYYY and other DD/MM/YYYY. I would suggest you go to power query and adjust the following settings.

Then publish it again and update the app. 

This should solve it.

Kudos and mark as solution appreciated.