Forum Discussion
Solved
Date AddMonths
Hello, I am trying to using the dates in the left column and add the months listed in the right column to create a new column. Can someone explain what I’m doing wrong? Thank you!
Hi Km93
The issue seems to be a missing else clause.
In M, the syntax of an if expression must be
if <if-condition> then <true-expression> else <false-expression>For example, if you want to return null when the condition is false, you could write:
if [Contact Frequency] = 1 then Date.AddMonths([Last Contact Attempt],1) else nullSee here for more examples/discussion:
hi Km93 ,
Use this corrected formula to handle the text and numeric parts in Contact Frequency:if Text.Contains([Contact Frequency], "mo") then Date.AddMonths([Last Contact Attempt], Number.FromText(Text.BeforeDelimiter([Contact Frequency], " "))) else null
It extracts the numeric value before "mo" and applies Date.AddMonths accordingly.
Hi Km93
The issue seems to be a missing else clause.
In M, the syntax of an if expression must be
if <if-condition> then <true-expression> else <false-expression>For example, if you want to return null when the condition is false, you could write:
if [Contact Frequency] = 1 then Date.AddMonths([Last Contact Attempt],1) else nullSee here for more examples/discussion: