Forum Discussion
Unpivot column into NEW table?
Generally you would create a new query, perhaps a copy of the old query, remove all of the other columns and then unpivot. Tought to say exactly without actual data and example of what you are trying to achieve. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Also, ImkeF might be able to decipher what you are trying to do.
Thanks.
In this case I am pulling data in from an SPO list and it takes a few minutes for the data to load.
I'd hate to have to re-query that same source a second time.
Is there anyway to use DAX or M query language to make an in memory table or calculated table?
The table looks like this:
PKID, Issue Title, Source1, Source2, Source3, other_columns
I would like to unpivot just Source1, 2, and 3, bring the PKID with them into the new table. Additionally, I want to leave the original table unchanged.
You might look at doing this in DAX. You could create a new table using something like SUMMARIZE perhaps. Tough to say without an example of the data involved and expected result.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Greg is right: If you want to be sure that the data isn't loaded again, you should use DAX.
