Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
3 years ago
Solved

Add Column Month & Year in Power Query

Hi BI Community Team,

 

I am getting error as the screenshot when trying to add/combine the column Month No. & Year to new column as the format: 1/1/2022 ---- 1/12/2022.

 

In Custom column formula = #date([Month No],[Year],1)

 

 

 

Any suggestion/advise of this case?

 

Thanks and Regards,

Need Help

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    3 years ago

    Hi ADSL 
    There are several ways to achieve your date format.
    You can use the "column from example" functionality as follows:
    1. Select the year and month columns

    2. Add column from example

    3 . In 2-3 lines, type the date in the desired format + press ok

    (2 was enough for me, and he understood the logic)

    4. Chnge data type to "date"

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.