Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Pricey79
Helper V
Helper V

Data all in one Row

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:

 

Pricey79_1-1692713611149.png

 

An example of what I want it to be:

Pricey79_0-1692713496014.png

 

Any help much appreciated

 

Thank you 

 

3 REPLIES 3
CharbelArmaleh
Resolver II
Resolver II

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.