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

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.