Skip to main content

Power BI

Needs Votes

Merge tables with a condition specified in the user interface.

Vote (2) Share
drigloff mefistoguru's profile image

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)

Comments (1)
drigloff mefistoguru's profile image Profile Picture

Karthik Palaniswamy on 25 May 2022 21:26:32

RE: Merge tables with a condition specified in the user interface.

Yes, We need a Conditional merge while joining tables in Power Query. It really helps solve some complex problems.