drigloff mefistoguru on 23 Dec 2017 21:36:23
When combining tables, it is often necessary to attach only part of the data on the conditions. Now you have to manually edit the request and this kind of connection becomes too difficult for novice users.
It is necessary to add a block with conditions in the table joining interface at the bottom, in which you could specify all necessary ones.
Based on the results of the given conditions, create the function of selecting the necessary data and add rows of the table through it. (like https://community.powerbi.com/t5/Desktop/Table-merge-in-Power-Query-based-on-conditions/td-p/183425)