Tips to avoid multiple merge steps in 1 query

[vonckk]

 Hey All,

I'm hoping to solicit some tips and/or advice.  I have a query where I'm taking a piece of data, which is really a low-level hierarchy number.  From that, I'm breaking it out into it's component parts (higher levels in the hierarchy) and for each level that I break out, I'm grabbing a description from a second table.  Unfortunately, the only way I know how to do this is through merging the same two tables multiple times in the same query.  It is extremely draining and takes forever to update.  

First set of steps (breaking out component parts of the hierarchy)

Second set of steps (many, many merges)

Does anyone know of a different way to approach this problem?  I'd love to only merge the data one time, if possible?

Link Below:

https://rocketsutoledo-my.sharepoint.com/:x:/g/personal/kvonck_rockets_utoledo_edu/EfPiQxyOIh9PgH_Zu...

[Vera_33]

Hi @vonckk 

I guess you put it in your one drive, and it does not allow people outside your organization to access directly...I will pm you my email, then you can send your sample data

[Vera_33]

Hi @vonckk 

You need to provide some sample date in a format that everyone can copy, and expected results. You can use dummy data, it's too difficult to imagine what you are doing without enough context.

[vonckk]

Thanks @Vera_33  I'm attaching an excel file with the Power Query's in question.  I'm most concered with the [WBS Standard] query.

Thanks!