Concatenate Year, Month, Day column to one date column in direct query

[Anonymous]

Hi,

I am trying to concatenate Year, Month and Day column into one column in power BI.

I tried with Date = FORMAT(DATE('Table'[YEAR],'Table'[Month],1),"MM-YYYY").

But it seems Format doesn't work for directquery.
Can anybody please help me to slove this?

Your urgent response will be highly appriciated.

Thank you 🙂

[lbendlin]

What are you trying to achieve, a date column, an integer column, or a string column?