Combining Data

[jdninob]

Hi everyone.

So I have two tables composed by:
-Start Date, End Date, Adgroup Name, Clicks, Spent, Orders and Sales.

So I'm trying to link those 7 labels by Adgroup name (one table is data from 2W ago and the other one is data from Last Week), so I can see a percentage change and clicks from both of the spreadsheets. I've been able of linking clicks and spend, but it has been imposible to me, as well the %change.

Any idea guys? I have something like:
2W ago table:
Adgroup Name Clicks Spend Orders Sales Start Date End Date
A. 0. $0 0. $0. 2019-1-6. 2019-1-6
B. 17. $0.54. 5. $15. 2019-1-7. 2019-1-10
C. 5 $0.11. 1. $3. 2019-1-7. 2019-1-7

The Last Week Table is the same, but only the Adgroup match (anything else is different).

I want to display a report in such way that if I select an Adgroup name, I can see clicks from each table and the %change between those two numbers. (I've tried creating a calendar table but didn't work)


Thank you!

[v-chuncz-msft · Accepted solution]

@jdninob,

You may refer to the following post and add measures.

https://community.powerbi.com/t5/Desktop/One-slicer-for-two-tables-M-M/td-p/523095