Forum Discussion

kumarleau's avatar
kumarleau
Frequent Visitor
8 years ago
Solved

Advance Editor dateadd function issue

Hi,   I am trying to do add a calculate column through advance editor by adding dateadd function to the date column. It is giving me error that dateadd function was not recognized. Please help me...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi kumarleau,

     

    It seems to be that you may mix DAX and Power Query(M). DATEADD function is a DAX function, so it cannot be used in Query Editor. You should use it under Modeling tab like below. :smileyhappy:

     

     

    Regards

  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    Apparently you didn't understand the reply.

     

    DATEADD is a DAX function. You can't use DAX functions in the query editor.

     

    Instead, try Power Query (M) function Date.AddYears

     

    Power Query (M) and DAX are 2 completely different languages within Power BI.

kumarleau's avatar
kumarleau
Frequent Visitor
8 years ago

Hello Experts, Any this.

 

Regards,

Kumar

  • SivaMani's avatar
    SivaMani
    Resident Rockstar
    8 years ago

    kumarleau,

     

    Could you please share your sample code here?