ahmedismailfourtex
Board Regular
- Joined
- Apr 28, 2015
- Messages
- 124
Hello,
I have 2 tables in PBI Like in below:
Table1:
Table2:
The Idea is bringing top 3 items from table 2 to table 1 in the same row (A,B,C).
Thanks in advance.
I have 2 tables in PBI Like in below:
Table1:
Top Items (Needed Column) | Category | ID |
(D,C,B) | X | 1 |
(A,B,E) | Y | 2 |
(D,B,C) | Z | 3 |
Value | Item | ID |
2 | A | 1 |
3 | B | 1 |
4 | C | 1 |
7 | D | 1 |
5 | A | 2 |
4 | B | 2 |
1 | C | 2 |
2 | D | 2 |
4 | E | 2 |
3 | A | 3 |
5 | B | 3 |
4 | C | 3 |
8 | D | 3 |
4 | E | 3 |
2 | F | 3 |
Thanks in advance.
