Creating an Email Campaign Analysis Report

[UW_Ziggy]

Hello Everyone- Brand New to Power BI Desktop, so take it easy on me.

- I have 5 emails with individual click stats of each email in a table that I have uploaded in Power BI desktop.  So now I have 5 email results table, and they all have a common key.  

I am trying to create a query in Power BI and pull in some fields from each table and give a combined view of the data from 5 tables.  How do you do that, so I can show the journey of emails and maybe even clicks of the people that did open/click on any or all emails?

[v-yulgu-msft · Accepted solution]

Hi @UW_Ziggy,

You could try the Merge and Append features in Query Editor mode.

Regards,

Yuliana Gu

[Hardik]

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

Hope this helps !