Forum Discussion
Unpivot column into NEW table?
I have 6 columns I need to unpivot into a new table. I cannot seem to figure out how to do this in Power BI Desktop. I can unpivot, but then it duplicates all the rows of my existing table as...
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.