Forum Discussion
Solved
Show Benchmark Data from Separate Table
I currently have two seperate tables of data, one which contains information on a number of products, and a seperate table that has benchmark data related to the products. What I am hoping to achieve...
Hi, SarneyB ;
You could append two tables in power query.
1.merge table1 to table1.2.append it.
3. if we select slicer product 1. the final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserSarneyB , Unpivot Year % column in both tables. And then create common dimensions Benchmark and year.
Then you can create measures product1, benchmark 1, and display them on a matrix using Switch on row and year on column