Forum Discussion
Solved
Merge Queries - Expanded Table uses a formula
Hello Community - I am in need of some assistance. I have a step in Power query where I am merging queries. Once merged, I am expanding a single column from that merged query which is a 'Bonus...
Hello ryan_b_fiting ,
you cannot include the calculation in the Expand-step/formula.
But if you are sure that there will be always just one row in the merged column, then instead of expanding the table, you could reference the required field in the unexpanded table instead like so:Table.AddColumn(#"Merge Bonus Data", "myCalculation", each [Bonus]{0}[#"Rate with Vacancy Hedge"] * [#"Salary($)"])
Hello ryan_b_fiting ,
you cannot include the calculation in the Expand-step/formula.
But if you are sure that there will be always just one row in the merged column, then instead of expanding the table, you could reference the required field in the unexpanded table instead like so:
Table.AddColumn(#"Merge Bonus Data", "myCalculation", each [Bonus]{0}[#"Rate with Vacancy Hedge"] * [#"Salary($)"])