Creating a Date column or measure with two existing columns, Month (Text) and Year (Text) formats

Dax for the column YYYY-MM:

YYYY-MM = 'Table'[YYYY] & "-" & Right("00" & 'Table'[MM], 2)

YYYY ~ Number, MM ~ Text 

Hi Anonymous ,

I think sevenhills 's method is the most convenient and it has solved your issue,so please kindly Accept his reply as the solution. More people will benefit from it. 

You could also try:

YYYY-MM = FORMAT(CONVERT(COMBINEVALUES(" ",[Year],[Month Number],"1") ,DATETIME),"YYYY-MM")

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