nested if
1 TopicNested If
Trying to do a nested if have issue if someone can please assist - TY Any of conditions to the left need to populate a 3rd column tagged to be reviewed = Table.AddColumn(#"Expanded EZ Nodes", "Tab_Review_Live", each if (OR [DeviceStatus] = "Disposed", "Inventory", "Missing", "Return to Client" and [DisplayLabel] = "Live", "Review Live", if (OR [DeviceStatus] = "Active", "Inventory", "No Power" and [DisplayLabel] = "Disposed Devices", "Review Disposed", if ([DeviceStatus] = "Disposed" and [DisplayLabel] = "Old Devices", "Review Old", null)))))Solved1.2KViews0likes2Comments