Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

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