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.

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
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

  • kumarleau's avatar
    kumarleau
    Frequent Visitor
    8 years ago

    Hi,

     

    Thanks for your reply.

     

    let
        Source = Sql.Database("ebi-etl-dev-01", "dbname"),
        dbo_Report_Booking_Live = Source{[Schema="dbo",Item="Report_Booking_Live"]}[Data],
        OpportunityCreatedDate1 = dbo_Report_Booking_Live[OpportunityCreatedDate]
        OpportunityCreatedDate2=DateAdd(opportunityCreatedDate,-1,year)
    in
        OpportunityCreatedDate1

    • MarcelBeug's avatar
      MarcelBeug
      Community Champion
      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.