Forum Discussion
Solved
How to get the next date from another column using IF / OR statement
I am trying to build a formula which basically tells me what the next date. e.g the one highlighted below what I want is to show the date from engage to lost as this was the next date. I need to do t...
Thank you. This works works and is exactly what I needed. Thanks alot
bhanu_gautam
Super User
Super UserJPSingh , Try using updated formula
m
= Table.AddColumn(#"Expanded Lost (Createddate)", "Diagnose Date to Next Step Date", each
if [Engage Created Date] <> null then [Engage Created Date]
else if [Prescribe Created Date] <> null then [Prescribe Created Date]
else if [Propose Created Date] <> null then [Propose Created Date]
else if [Conclusion Created Date] <> null then [Conclusion Created Date]
else if [#"Won (Createddate).Created Date"] <> null then [#"Won (Createddate).Created Date"]
else if [#"Lost (Createddate).Created Date"] <> null then [#"Lost (Createddate).Created Date"]
else null)