Create Date column from Year and Month columns

[DSwezey]

I have a table with a column of Month NUmber and a column for Year. I want to make a date column for the 1st of the month. The new column I want to be formatted [Month Number]/1/[Year] 

Example: the second row is February 2021. I want the new date column to look like 2/1/2021.

[smpa01 · Accepted solution]

@DSwezey  this was to be done in PQ.

For DAX use this 

Column = DATE('Table'[Year],'Table'[Month Number],1)

[smpa01]

@DSwezey  create a new column as 

#date([Year],[Month Number],1)

and then format as you wish through DAX

[DSwezey]

I get this error when adding the custom column. 

[ronrsnfld]

date <> #date

change 

date([Year],[Month Number],1)

to (as written by @smpa01 )

#date([Year],[Month Number],1)