Loading wrong dates

[pimsbi]

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

[amitchandak · Accepted solution]

@pimsbi , Do not change the datatype to date. keep it datetime.

In dax Create a date column and try

date = Datevalues([Datetime])

[pimsbi]

It worked by not forcing type conversion in power query.

then simply formatting as Short date in dax.

Thank you