Forum Discussion
Solved
Power Query - Self Referencing Tables for adding comments etc
So after reading this thread I figured I'd try my hand and follow instructions from this https://exceleratorbi.com.au/self-referencing-tables-power-query/ However, after a bit of testing this mor...
davidmaddock54 The posting you referred to included one link (of many) to an article about how to create self referencing tables in PQ. Looking at your particular situation, perhaps the attached version works better for you. All is condensed into one query.
See if you can follow the steps, though it required some manipulation of the M-code. The key is that you create two Sources and merge one to the other within the same query.
So I rewrote it to where the collateral pipeline is my master query. I then created a 2nd table from that query labeled "source" and added in my columns. However, when I go back to Power Query Editor, it is not showing my added columns so I am unable to then merge.