Forum Discussion

AlexTandem's avatar
AlexTandem
Frequent Visitor
9 years ago

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 ...
AlexTandem's avatar
AlexTandem
Frequent Visitor
9 years ago

It's almost what I need, thank you!

I did as you said, but now I see another problem.

I need to sum total spent money (that's ok now) but also sum per every day for both yandex and Google.

 

When i use your method, one of the traffic sources shows me exactly the same ammount of money spent per each day.

For example, if I use cost and date from Yandex table and cost from Google table, in Google all the spent money are the same for each day.

 

I attache screenshot to show you how if looks like

https://yadi.sk/i/vzJF8k71v7BWX

 

Is there any way to sum each day for different tables?

 

Thank you!

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

AlexTandem

 

If you have two tables which are similar as below. You can try with following measure formula.

 

Totalad = 
SUMX (
    Yandex,
    CALCULATE (
        SUM ( adwords[adwords cost] ),
        FILTER ( adwords, adwords[Date] = Yandex[Date] )
    )
)

 

Best Regards,

Herbert