Compare values and enter data

Question

Hello....&nbsp;I have two tables&nbsp;----------------TABLE ASISTENCIAS------------------------ID&nbsp; &nbsp; &nbsp; &nbsp; NAME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PARTNER&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EMAIL6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PEDRO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MICROSOFT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xxx@xxx.com7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MANUEL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AMAZON&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;xxx@xxx.com8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JUAN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;GOOGLE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;xxx@xxx.com----------------------------------------------------------------&nbsp;I want to compare the ID value of the Attendance table with the Attendance value of the Reports table and then take the data (names, Members and Mail) and add it to the reports table.I want this result.&nbsp;----------------TABLE REPORTS---------------------------ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TIME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DETAILS&nbsp; &nbsp; &nbsp; ASISTENCIA&nbsp; &nbsp; &nbsp; NAME&nbsp; &nbsp; &nbsp; &nbsp;PARTNER&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EMAIL100&nbsp; &nbsp; &nbsp; 12-03-2022&nbsp; &nbsp; &nbsp; &nbsp;10.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WALK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PEDRO&nbsp; &nbsp; &nbsp; MICROSOFT&nbsp; &nbsp;&nbsp; xxx@xxx.com200&nbsp; &nbsp; &nbsp; 15-03-2022&nbsp; &nbsp; &nbsp; &nbsp;11.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PLAY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MANUEL&nbsp; &nbsp; AMAZON&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xxx@xxx.com300&nbsp; &nbsp; &nbsp; 17-03-2022&nbsp; &nbsp; &nbsp; &nbsp;12.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SLEEP&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JUAN&nbsp; &nbsp; &nbsp; &nbsp; GOOGLE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; xxx@xxx.com&nbsp;Thanks you&nbsp;

ba_pete · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
1) In Power Query, select your Reports table then go to the Home tab &gt; Merge Queries.
2) When the dialog opens, select the [ID] column from the top preview window.
3) From the dropdown list near the bottom preview window, select your Attendance table.
4) In the bottom preview window, select the [ASISTENCIA] column.
5) Near the bottom of the dialog, make sure the 'Join Kind' dropdown shows LEFT OUTER.
6) Hit OK to merge, then use the button at the top-right of your new column which looks like two arrows bending away from each other to choose the columns you want to expand.
&nbsp;
Pete

Forum Discussion

Compare values and enter data

1 Reply

Related content

Lookup for a value and compare DAX

Comparing measure and column value

Compare values

Compare one value to multiple columns values

Comparing values between different tables

Forum Discussion

Compare values ​​and enter data

Lookup for a value and compare DAX

Comparing measure and column value

Compare values

Compare one value to multiple columns values

Comparing values between different tables

Compare values and enter data