Forum Discussion
Create a new table from existing data in another table
Super UserPlease 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
This is what the sample table looks like now:
This is what I want the new table to look like:
- lbendlin
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.
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.