- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is what the sample table looks like now:
This is what I want the new table to look like:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-03-2024 08:57 AM | |||
03-04-2024 09:57 AM | |||
10-20-2023 11:50 AM | |||
Anonymous
| 04-27-2023 11:57 AM | ||
10-26-2023 09:51 PM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |