if and statements with date columns if null

The first if statement is working the rest are coming up as erors where am i going wrong ?

if [#"Date 1"] = null then [#"Date 2"]

else if [#"Date 1"] = null and [#"Date 2"] = null

then [#"Date 3"] else 0

Any help greatly appreciated

Omid_Motamedise
1 year ago
Hi,
The order of condition is not appropriate, in the first condition if [#"Date 1"] = null is true, it result in [#"Date 2"] which might be null also, so revise the formula as follow

if [#"Date 1"] = null and [#"Date 2"] = null

then [#"Date 3"] else if [#"Date 1"] = null then [#"Date 2"]

else 0
ZhangKun
1 year ago
You can also use the following magical writing method:

[#"Date 1"] ?? [#"Date 2"] ?? [#"Date 3"] ?? 0

Forum Discussion