Create a new table from existing data in another table

Question

I want to create a new table but use the unique values in an existing table column as the column headers for the new table and then pull over the values (dates) associated with the values of the headers.&nbsp; So for example my exsisting table has values in ColumnA (Permit, Survey, Installation, etc.)&nbsp; I want to put those as my headers in the new table.&nbsp; Then take the dates that are associated with those values from existing table and bring them over to my new table under the corresponding values in the header.&nbsp; I cannot find a solution to this.&nbsp; HELP!

lbendlin · Answer

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

anonymous · Answer

This is what the sample table looks like now:&nbsp;&nbsp;This is what I want the new table to look like:&nbsp;

lbendlin · Answer

That looks straightforward.&nbsp; Use a Matrix visual. Put the Order # in the rows. Put the Name in the Columns, Put the End Date in the values.

anonymous · Answer

Yes, thank you.&nbsp; I need it to be in an actual data table so that I can add a calculated column to calculate different SLAs.&nbsp; So for instance:Sorry, I should have included that info, but all I need is to know how to create a new table from this existing data and then I can do the rest of the calculations.&nbsp;

Forum Discussion

Create a new table from existing data in another table

4 Replies

Related content

Replace existing image with another

Get first date a value from another column exists

Cannot create liquid clustering on existing unpartitioned table

Create column to check if ID exists in another dataset

Check if a value exist in another column