Add Column Month & Year in Power Query

[ADSL]

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,

[danextian]

Hi @ADSL

AFAIK, #date should be in this order - year, month, day.

[FreemanZ · Accepted solution]

hi @ADSL 

how about:

= #date([Year], [Month No],1)

[Ritaf1983]

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.