Forum Discussion

raymond's avatar
raymond
Post Patron
9 years ago

Merging from 3 different Tables into a single report

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?

 

Need Help

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    9 years ago

    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

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    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. :smileyhappy:

     

    Reference: 

    Append vs. Merge in Power BI and Power Query

    Power BI Desktop : Merge Query Options

     

    Regards