Forum Discussion

gaby58's avatar
gaby58
Frequent Visitor
1 year ago

Multiple If with Multiple Conditions

Hi All,     Need help in creating a Custom Column. I have 2 columns and need to check values in first column, based on that I need to check values in another column, this one has multiple values, d...
Need Help
gaby58's avatar
gaby58
Frequent Visitor
1 year ago

Finally I got it to work

 

if
([Section Stage]="Complete" or [Section Stage]="In Progress") and ([DateLeft_Adjusted] = Date.From(#date(2024,12,20)) or [DateLeft_Adjusted] = Date.From(#date(2024,10,11))) then #date(2025,1,7) else if ([DateLeft_Adjusted] = Date.From(#date(2025,3,7)) or [DateLeft_Adjusted] = Date.From(#date(2025,5,22))) then Date.From(#date(2025,6,5))
else
Date.AddDays([DateLeft_Adjusted], 1)

 

Thank you all for the tips, appreciate it