Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date Format issue

   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's avatar
    FrankAT
    6 years ago

    Hi,

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

     

    Regards FrankAT

FrankAT's avatar
FrankAT
Community Champion
6 years ago

Hi,

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

 

Regards FrankAT