Forum Discussion

raphazzz's avatar
raphazzz
Helper I
3 years ago
Solved

Error converting DATE in the Power Query...

Hello friends,   I'm trying to convert a text column to date format to sort the visualizations in chronological order, but I'm getting errors in Power Query. I tried with different date formats (Ja...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    raphazzz 

    try to add "-1" after month, then you can convert.

    [Column1]&"-1"

ryan_mayu's avatar
ryan_mayu
Super User
3 years ago

raphazzz 

try to add "-1" after month, then you can convert.

[Column1]&"-1"

raphazzz's avatar
raphazzz
Helper I
3 years ago

Thanks, it did work, but just out of curiosity, can you explain why?

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    3 years ago

    I learned this from other experts on this community. ğŸ˜„