Forum Discussion
Custom Column Formula Error - not getting expected results
Hi Experts
I have the following Custom Column Formula
if [Sales Date] >= Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1)) and [Date] <= Date.EndOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1))
then "Actual" else "4YOP"
When i add the new column it give me dates that are in 2012, 2021 (jan) as "4YOP" when they should be Actual and Feb 21, Mar 21 and April 21 as Actuals...
All Future dates i.e March onwards should be "4YOP" and all historical dates "Actuals"....
Anonymous ,
if [Sales Date] <= Date.EndOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1))
then "Actual" else "4YOP"
1 Reply
Anonymous ,
if [Sales Date] <= Date.EndOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()),-1))
then "Actual" else "4YOP"