Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create Date column from Year and Month columns

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...
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    Anonymous  this was to be done in PQ.

    For DAX use this 

    Column = DATE('Table'[Year],'Table'[Month Number],1)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I get this error when adding the custom column. 

 

ronrsnfld's avatar
ronrsnfld
Super User
4 years ago

date <> #date

 

change 

 

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

 

to (as written by smpa01 )

     

 

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