Merging from 3 different Tables into a single report

[raymond]

Dear Community,

I do have a rather simple issue and I seek your help.

I have received 3 simple reports - see files attached. There are from a LinkedIn campaign and come in different tables.

The goal is, to have one report with a matrix, that tells me LinkedIn Display has 8500 Impression in week 23 respectively LinkedIn Post with 1500 Impression (in one Column only). Additionally and from the 3rd table I would like to see whether there has been an OptIn or Double OptIn.

An example report is here:

Unfortunately I wasnt able to display the impression for single items, instead PowerBi wanted me to arrange it in 2 columns.

Furthermore I couldnt connect the the opt-in counts.

Does anyone of you have a hint for me?

[v-ljerr-msft]

Hi @raymond,

According to your descriptions above, I would suggest you append the first two tables into a single table first using the Append Queries option in Query Editor.

Then you should be able to use the Merge Queries option to merge the third table and the appended table into a single table.

So finally, you will have only one table with all the data, and it should be easy to get your expected result on the report from that table. 

Reference: 

Append vs. Merge in Power BI and Power Query

Power BI Desktop : Merge Query Options

Regards

[MFelix]

Hi  @raymond,

Create a separated table with week (1-52) then make a relationship between that table and your other 3 tables then use that value to make your calculations to the final summary.

Regards,

MFelix