Forum Discussion
Solved
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...
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 :smileymad:
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 :smileymad: