Forum Discussion
Expression error: The name 'Concatenate' wasn't recognized
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
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
3 Replies
v-lili6-msftCommunity Support
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