7.07 Variables (0:05:26)
Once you've created your List.min([column name]) is there a convenient way or is it even possible to reference that outside of PQ in excel formulas?
Ex. =Concatenate("The average test score was", #"Average Score")
?
Hi Wesley,
If you wanted to reference anything outside of Power Query, you have to load it to the worksheet. If the average score is something you wanted, you can 'close & load' that query to a table in the Excel file.
Mynda
Is there a way to access a "connection" without loading it? Ex. If I had duplicate a query, average the score column so I have basically a single-number (56.67 - hypothetical) and then load as connection....
Can I reference it as a connection from a cell somehow? Or is there no way except to throw it on a sheet on a table somewhere? It just seems like a potential waste of a cell. I was hoping similar to the [@Rider].Position example there would be some.... [#"Average Score Query"] or something similar....
In theory, I could add a sheet for pasting my queries onto....and then just hide the sheet? The data would still be accessible to formulas even of the sheet is hidden from user views?
Currently, the only way to access data from a query is to load it to a cell in the worksheet, or load it to a PivotTable or the Data Model. You cannot access Connection Only data from the grid.
