Forum Discussion
Loading wrong dates
Hi everybody,
I am dealing with dates in PowerQuery transforming a datetimezone column in a Date column. the dates appear to be the ones I am expecting (e.g. 12/31/2021).
When loading the table into Desktop, however I see wrong dates (e.g. 12/30/2021)
I assumed I had truncated the timezone information and I expected to find exactly the same date. However this is not the case.
What am i missing ?
thanks in advance
pimsbi , Do not change the datatype to date. keep it datetime.
In dax Create a date column and try
date = Datevalues([Datetime])
2 Replies
- amitchandak
Super User
pimsbi , Do not change the datatype to date. keep it datetime.
In dax Create a date column and try
date = Datevalues([Datetime])
It worked by not forcing type conversion in power query.
then simply formatting as Short date in dax.
Thank you
