Forum Discussion
Solved
Add column previous step (drill-down)
Hello, I have query where I created some intermedieries steps calculating a value, which has been drilled down. This step is called "Prior". In the same query, I have a table and I want to ad...
Thanks, but I found it too complicated.
I replicated the original formulas within the column.
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.