Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jdninob
New Member

Combining Data

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!
1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors