Forum Discussion
Merging multiple tables in power query
Hi all. Brand new user here, but I've been lurking for a few weeks. I'm new to Power BI, and while I think I'm getting close to a solution I still don't have things quite right regarding my use of Po...
Duplicated Record IDs as opposed to what you show as you "goal for the data outcome". BTW there is no "Append function" in M language. It's a UI's name which effectively resembles to Table.Combine function behind the scene that I use in the very first row of code.
I appreciate the help! I'm still using fairly surface level operations here, as I haven't used power.bi much before now. I'm glad that the built in append function works similar to what you were referring to.
When I ran the append function, it did give me about 20 duplicates of the Record ID lines. I ran a remove duplicates tool which pulled those and left me with what looked to be a clean data set, although i haven't verified that all 600 lines transferred properly.