Log In
Register
Home
Expand table to include another table
Garb I
Active Member
Members
Forum Posts: 4
Member Since:
July 21, 2021
July 21, 2021
Offline1
August 2, 2022 - 6:41 pm
Hi
I have multi level BOM with 2 sheets in excel. I want to expand and try to see all the components within one table as per the sample. I'm wondering if the power query will be able to do that for me?
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members
Trusted Members
Moderators
Power BI
Trusted Members
Moderators
Power BI
Forum Posts: 440
Member Since:
January 31, 2022
January 31, 2022
Offline2
August 2, 2022 - 10:09 pm
With a 2-level BOM it's relatively easy. With your set-up it takes a merge, a few consecutive steps of combining columns and cleaning up. Quite easy to follow. If your real situation has more levels it becomes more complicated.
In the attached file I've added a PQ solution for you to consider.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria
Guest(s) 12
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Hayden Hao
Angela chen
Sean Moore
John Chisholm
vexokeb sdfg
John Jack
Malcolm Toy
Ray-Yu Yang
George Shihadeh
Naomi Rumble
Forum Stats:
Groups: 3
Forums: 24
Topics: 6211
Posts: 27238
Member Stats:
Guest Posters: 49
Members: 31891
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —