cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kumarleau
Frequent Visitor

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 on this issue.

 

Regards,

Kumar

2 ACCEPTED SOLUTIONS
v-ljerr-msft
Microsoft
Microsoft

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. Smiley Happy

 

c1.PNG

 

Regards

View solution in original post

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.

Specializing in Power Query Formula Language (M)

View solution in original post

5 REPLIES 5
v-ljerr-msft
Microsoft
Microsoft

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. Smiley Happy

 

c1.PNG

 

Regards

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

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.

Specializing in Power Query Formula Language (M)
kumarleau
Frequent Visitor

Hello Experts, Any this.

 

Regards,

Kumar

@kumarleau,

 

Could you please share your sample code here?

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors