Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello
I was hoping someone could help me please
I have a table of data with multiple columns. One of these columns is called RECORD , and this is used to differentate records, Record 1, Record 2, Record 3 etc.
If I filter to a record, say Record 1 , I only have one row of data but with multiple columns for that row. For example, the Owner of the record and the due date that record AND the Owner of the check of the previous Owners task and a due date
How can I split this out to have one table with separate rows?
An example of what it currently is:
An example of what I want it to be:
Any help much appreciated
Thank you
Hello,
you can do that using PowerQuery,
1- duplicate the table and remove the Column B and C
2- append the 2 tables again
Regards
Did I answer your question? Mark my post as a solution!
@CharbelArmaleh Thank you for taking the time to reply.
If I had more columns, say an F and G column. Would I just repeat the process and append the 3 tables please?
yes if you have to create a third line for F and G
Regards
User | Count |
---|---|
141 | |
70 | |
70 | |
54 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |