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

Date.Addmonths... Not recognised?? What am I doing wrong?

I am using Power Query (actually for Excel for this instance, but also for Power BI).

 

I have

  • A date column [Forecast Month]
  • An integer column [Add Month]

I want to create a calculated column, a second date field, by adding the integer (in months) to the original date column.

Please note: I am in Australia, the dates are formatted dd/mm/yyyy

 

The formula I have tried is

Date.Addmonths([Forecast Month],[Add Month])

However Power Query is throwing this error code:

 

Expression.Error: The name 'Date.Addmonths' wasn't recognized.  Make sure it's spelled correctly.

 

I sourced this formula directly from the "learn about Power Query formulas" link that is inside Power Query formula window... What am I doing wrong?

 

Forecast1.JPGForecast2.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Scotty89 Frequent Visitor
Frequent Visitor

Re: Date.Addmonths... Not recognised?? What am I doing wrong?

Nevermind....

 

I tried Date.AddDays, worked. Tried Date.AddYears, worked... Date.AddQuarters... worked.

 

Turns out the formula is CASE SENSITIVE. It needs to be Date.AddMonths not Date.Addmonths Smiley Mad

View solution in original post

1 REPLY 1
Scotty89 Frequent Visitor
Frequent Visitor

Re: Date.Addmonths... Not recognised?? What am I doing wrong?

Nevermind....

 

I tried Date.AddDays, worked. Tried Date.AddYears, worked... Date.AddQuarters... worked.

 

Turns out the formula is CASE SENSITIVE. It needs to be Date.AddMonths not Date.Addmonths Smiley Mad

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 70 members 1,228 guests
Please welcome our newest community members: