Forum Discussion
Add column previous step (drill-down)
Thanks, but I found it too complicated.
I replicated the original formulas within the column.
This should be like below where Prior is the last step and Sales is the column which was drilled down
Table.AddColumn(#"Removed Columns", "Custom", each Prior[Sales])
If the step which generated the list is named test, then use following
= Table.AddColumn(#"Custom1", "Custom", each test)
In the second query, you are referring to the last result which is a list which will work in Query1. In above Prior[Sales] is the list.
Not sure I understood correctly.
First of all, "Prior" step has been drilled down. so there is only one value associated with that step.
I tried to pass the following: Table.AddColumn(#"Removed Columns", "Custom", each Prior), but I got the Forumla.Firewall error.
I am looking on the internet to figure out how to solve it...
any idea?
If this is a single value list.
Table.AddColumn(#"Removed Columns", "Custom", each Prior{0})
For formula.firewall - https://docs.microsoft.com/en-us/power-query/dataprivacyfirewall
Thanks, but I found it too complicated.
I replicated the original formulas within the column.