Forum Discussion
Solved
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 int...
pimsbi , Do not change the datatype to date. keep it datetime.
In dax Create a date column and try
date = Datevalues([Datetime])
amitchandak
Super User
Super Userpimsbi , 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