“if” function in Power Query not working properly
Good day, I have a power query set up that is giving me the number of days between task completions during a large project.
However, I am missing the time from the last completed task until “today” for any Job sites that are not fully completed yet.
=if [#”Final Walkdown”] = [#”Completed”]
then [#”0″]
else ( if [#”Final Walkdown”] <> “”
then [#”Completed”]-[#”24-Hour Run Test”]
else ( if [#”24-Hour Run Test”] <> “”
then [#”Completed”]-[#”Rotor Install”]
else ( if [#”Rotor Install”] <> “”
then [#”Completed”]-[#”Rotor Removal”]
else ( if [#”Rotor Removal”] <> “”
then [#”Completed”]-[#”Prework Walkdown”]
else “0”))))
I get a valid result up until then [#”Completed”]-[#”24-Hour Run Test”].
Any fields beyond that just return “null”.
Any tips?
Good day, I have a power query set up that is giving me the number of days between task completions during a large project. However, I am missing the time from the last completed task until “today” for any Job sites that are not fully completed yet. =if [#”Final Walkdown”] = [#”Completed”] then [#”0″] else ( if [#”Final Walkdown”] <> “” then [#”Completed”]-[#”24-Hour Run Test”] else ( if [#”24-Hour Run Test”] <> “” then [#”Completed”]-[#”Rotor Install”] else ( if [#”Rotor Install”] <> “” then [#”Completed”]-[#”Rotor Removal”] else ( if [#”Rotor Removal”] <> “” then [#”Completed”]-[#”Prework Walkdown”] else “0”)))) I get a valid result up until then [#”Completed”]-[#”24-Hour Run Test”]. Any fields beyond that just return “null”. Any tips? Read More
