cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 269 members 3,140 guests
Please welcome our newest community members: