Date Format issue

[Anonymous]

Date Column

 Above is how the column looks like on my table, when i'm using the Format([Column], "YYYY MMM"), This function returns wrong year and month, does anyone knows how to fix this? 

[FrankAT · Accepted solution]

Hi,

go to power query editor and transform the column into a proper datetime column like 2020-01-16 13:53:43.

Regards FrankAT