Expression error: The name 'Concatenate' wasn't recognized

[Anonymous]

Hi,

I am using the below formulla:

CONCATENATE(MONTH([FIRST_TOUCH_DATE_TIME]),YEAR([FIRST_TOUCH_DATE_TIME]))

to get the year and month from a date, there is no syntax error occured , but when I press the OK button I am getting the error as 'CONCATENATE' is not recognized like below:

What should I do now? Please help

[v-lili6-msft · Accepted solution]

hi, @Anonymous

    CONCATENATE as DAX Function, and in the query editor, it needs to use M language. 

When you're modeling, you can use Dax Function to add a calculate column or calculate measure, but in the query editor,

you need to use M language.

and for your requirement in the query editor, you can use & as below

Best Regards,

Lin

[Anonymous]

Hi,

When I am doing calculation at query editor it gives me error, but when I doing this at dashboard by right clicking on the filed it works fine for me.

Please give me advise why I am getting error at query editor only?

Thanks

Sandip

[Anonymous]

Hi,

When I am doing calculation at query editor it gives me error, but when I doing this at dashboard by right clicking on the filed it works fine for me.

Please give me advise why I am getting error at query editor only?

Thanks

Sandip