Forum Discussion

FabMann's avatar
FabMann
Frequent Visitor
3 years ago

Power Query: Create a table from two different tables

Hello, I have two different tables (Table A, and Table B) with these fields Table A Date User Id   Table B Date email   I would like to create a third table (Table C) on Power Qu...
Need Help
bolfri's avatar
bolfri
Solution Sage
3 years ago

Try this steps:

Import Table A (mySample)

 

Import Table B (mySample)

 

New Source > Blank Query

Create a new table with combination of Dates from Table A and Table B

= Table.Combine({Table.SelectColumns(#"Table A",{"Date"}),Table.SelectColumns(#"Table B",{"Date"})})

 

= Table.Distinct(Source)

We want only unique values, so use Distinct.

 

Merge Table A and Table B on Date column.

 

Expand Table A ussing Aggregate "Count (Not Blank) of User ID"

 

Expand Table B using Aggregate "Count of Email"

 

FINAL RESULT:

 

PBIX FILE: https://we.tl/t-ysyNlMBzuu