The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
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
This is what the sample table looks like now:
This is what I want the new table to look like:
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.
User | Count |
---|---|
77 | |
75 | |
36 | |
31 | |
28 |
User | Count |
---|---|
95 | |
81 | |
55 | |
48 | |
48 |