Forum Discussion

hb0135's avatar
hb0135
Helper III
1 year ago
Solved

Getting Error Will concatenate the date in Power Query Editor

Hello,

While i am concatenating the 3 columns to get the date, I am getting an error.

 

Need Help
  • Irwan's avatar
    Irwan
    1 year ago

    hello hb0135 

     

    looks like date.day is followed by datetime format while in your case is an integer.

     

    how about using merge columns with delimiter "-"?

     

    Hope this will help.

    Thank you.

2 Replies

  • Irwan's avatar
    Irwan
    Super User
    1 year ago

    hello hb0135 

     

    looks like date.day is followed by datetime format while in your case is an integer.

     

    how about using merge columns with delimiter "-"?

     

    Hope this will help.

    Thank you.