Date AddMonths

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 null

See here for more examples/discussion:

https://bengribaudo.com/blog/2020/01/06/4844/power-query-m-primer-part14-control-structure#conditional-expressions-if

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.