Match row in one source to that in another

[Daryl_K]

I have a Power BI report that pulls data from two SharePoint lists. Each list has different data for the same projects, but order, date, etc. will not be the same. Similarly, they may be entered at different times, so Table A may have an entry for Project 1 that doesn't exist in Table B, and vice versa.

Both lists have hundreds of columns and thousands of rows, but there are three specific columns that I think (combined) can identify a project match, so what I am looking for is some DAX in Table A that will look through Table B, and if (for example):

Table A, Row 1, Column 1 = Table B, Row 8,  Column 1,

AND

Table A, Row 1, Column 2 = Table B, Row 8, Column 2

AND

Table A, Row 1, Column 3 = Table B, Row 8, Column 3

...then I extract a few select columns from the matching Table B row 8 over to matching Table A row for the needed functions.

Is this possible in Power BI and DAX?

[v-yiruan-msft · Accepted solution]

Hi @Daryl_K ,

Do you want to merge Table A and Table B base on the field project, order and date? If yes, you can refer the content in the following links to achieve it.

Join Datasets with multiple columns conditions in Power BI

Join tables based on multiple columns

If you only want to get the aggregated values of table A/B base on table B/A, you can refer the content in the following thread to get it.

Multiple columns join/goup

For example: get the sum of values in Table B base on matched info in Table A

Sum of Values =
CALCULATE (
    SUM ( 'Table B'[xxvalue] ),
    FILTER (
        ALLSELECTED ( 'Table B' ),
        'Table B'[Project] = SELECTEDVALUE ( 'Table A'[Project] )
            && 'Table B'[Order] = SELECTEDVALUE ( 'Table A'[Order] )
            && 'Table B'[Date] = SELECTEDVALUE ( 'Table A'[Date] )
    )
)

Best Regards

[PaulDBrown]

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M6071... 

Please follow the recommendations in this thread: