Not sure how to ask this question, but hopefully with the picture below it will be clear.
I was able to add my first CUSTOM COLUMN(Col U) in PowerQuery using the below formula and it worked well to retrieve the last Non-Null field in my list of dates.
CUSTOM COLUMN = List.Last(List.RemoveNulls({[#"WHS"],[#"CUSTOMS"],[#"DISPATCH"]}))
Now I can't seem to figure out if its possible to add the 2nd Custom Col. (COL V). Where it looks at the same information and picks the last non-null cell, but populates with the name of the header. (So Example below - Last non null for Row 1 is Col S, value = 3/27, and header = DISPATCH)
Does this make sense and/or is this possible?
I was able to add my first CUSTOM COLUMN(Col U) in PowerQuery using the below formula and it worked well to retrieve the last Non-Null field in my list of dates.
CUSTOM COLUMN = List.Last(List.RemoveNulls({[#"WHS"],[#"CUSTOMS"],[#"DISPATCH"]}))
Now I can't seem to figure out if its possible to add the 2nd Custom Col. (COL V). Where it looks at the same information and picks the last non-null cell, but populates with the name of the header. (So Example below - Last non null for Row 1 is Col S, value = 3/27, and header = DISPATCH)
Does this make sense and/or is this possible?