I am trying to add information from one query to others without merging or using DAX. It is literally to get one value appeneded across a whole column for each of the queries, but I want to draw it from another table so I can easily edit those values as needed.
So in that query I have this Weighting table:
| | Query 1 | Query 2 | Query 3 |
| Weight | 10 | 20 | 30 |
And I want to append those values to respective queries.
So far I have tried adding a Custom Column with the following expression:
= Table.AddColumn(#"Renamed Columns", "Weight", each Weighting[Query1]{0})
While that appears to produce a result, it takes a very long time to do given the small data set and also produces the following warning: "There are pending changes in your queries that haven't been applied."
Unfortunately, no amount of applying the changes seems to work, so I'm guessing something is amiss with this approach.
EDIT: the cause of the pending changes issue was that I had to select different privacy levels for the query I was appending from. As that was coming from my desktop I said to ignore privacy levels, but that caused the loop with pending changes.
Am I doing something wrong and/or is there a better way to do this, short of simply creating custom culumns within each query to directly specify the number?
