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

Anonymous — Fri, 09 Apr 2021 15:07:17 GMT

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 🙂

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

lbendlin — Tue, 13 Apr 2021 20:11:19 GMT

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