Forum Discussion

rosamhernandez1's avatar
rosamhernandez1
Icon for Helper I rankHelper I
9 months ago
Solved

Nested IF

Need help adjusting formula to only be calculated when the Development Status is "Active-Dev" or "Active-Exe"   Original formula is:  if [Interconnection Facilities ISD] <> null and Duration.Days...
Need Help
  • amitchandak's avatar
    amitchandak
    9 months ago

    rosamhernandez1 , Power query code 

    = if [Development Status] <> "Active – Dev" and [Development Status] <> "Active – Exe" then
    null
    else
    if [Interconnection Facilities ISD] <> null
    and Duration.Days([Projected In Service Date] - [Interconnection Facilities ISD]) >= 0
    and Duration.Days([Projected In Service Date] - [Interconnection Facilities ISD]) <= 30
    then "Yes"
    else "No"

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
9 months ago

rosamhernandez1 , Power query code 

= if [Development Status] <> "Active – Dev" and [Development Status] <> "Active – Exe" then
null
else
if [Interconnection Facilities ISD] <> null
and Duration.Days([Projected In Service Date] - [Interconnection Facilities ISD]) >= 0
and Duration.Days([Projected In Service Date] - [Interconnection Facilities ISD]) <= 30
then "Yes"
else "No"