Reply
avatar user
Anonymous
Not applicable

Create a new table from existing data in another table

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.  So for example my exsisting table has values in ColumnA (Permit, Survey, Installation, etc.)  I want to put those as my headers in the new table.  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.  I cannot find a solution to this.  HELP!

4 REPLIES 4
lbendlin
Super User
Super User

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-...
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

avatar user
Anonymous
Not applicable

This is what the sample table looks like now:

kristiszabo_0-1666617482240.png

 

 

This is what I want the new table to look like:

kristiszabo_1-1666617499596.png

 

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

avatar user
Anonymous
Not applicable

Yes, thank you.  I need it to be in an actual data table so that I can add a calculated column to calculate different SLAs.  So for instance:

kristiszabo_0-1666619703216.png

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.

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)