Forum Discussion
summing differetn tables
Hello eveyone!
I'm just starting to use power BI and I hope you can help me with one problem.
The thing is I download data about our cpc campaigns from Google Analytics and we have two different traffic resources - Google and Yandex.
I download them to BI with two queries and use filters for each traffic source.
So I have two tables - one for Adwords and another one for Yandex.
In Yandex everything's ok, and such things like cost, cpc and cpl give me no trouble.
But in Google adwords I have to use mesures to get correct data as we have comissions and taxes.
For example, for Adwords Cost of cpc campaigns look like this: cost*1.18/0.9
Same for CPC and CPL.
My problem is that I don't know how to sum this data from Adwords and Yandex to get total cost, av. cpc and av. cpl.
Your post is not quite clear. It could help if you displayed a brief sample of the 2 tables.
Sum could mean across the row, or it could be for the column of a table, or it could be a column of 1 table with a column of a different table.
Are there unique IDs common to the 2 tables that allow a join?...such that you seek a sum of 2 tables per ID?