Pivoting a non-query table in Power Query Editor

[Anonymous]

I made a table "Results" using the "Enter Data" option and DAX language. The table is four columns combined from different original queries and filtered on multiple conditions based on fields in related queries. The columns are metricID, locationID, TimePeriodName, and ActualResult.  I need to pivot two of the four columns: TimePeriodName and ActualResult so that the values in TimePeriodName become columns and ActualResults values become the values for those columns while perserving the metricID, and locationID columns.

The problem: I see how to pivot data in the Power Query Editor but I do not know how to reference the "Results" table since it isn't a 'query' but a table constructed using DAX and several different original queries.

The Question: How can I reference a non-query table in Power Query? Or alternatively, how I can pivot the data the way I need to using DAX?

[edhans · Accepted solution]

You cannot. Power Query cannot see tables created in DAX, nor tables from Live Connections. Power Query is an ETL tool - extract, transform, and load. Once it loads, what you do with that table on the other side in DAX, PQ cannot see those changes - so new calculated columns or calculated tables.

One exception is if you change a data type in Power BI. That actually goes back into Power Query and adds that Changed Type step.