Need help with formula, if assigned date = more than 3 months ago

[Michael11]

Hi all,

Have searched around but cant seem to comprehend exactly what i need to put. i would like to create a custom column whereby if an individuals 'Assign Date' is more than 3 months ago, it will appear with a Y in the column

[wdx223_Daniel · Accepted solution]

NewStep=Table.AddColumn(PreviousStepName,"Custom",each if Date.From([Assign Date])<Date.AddMonths(Date.From(DateTime.LocalNow()),-3) then "Y" else null)

[jbwtp]

DAX version, in case you want to create the calculated column:

Over3Months = datediff(today(), [Assigned Date], MONTH) <= -3