Forum Discussion
compare two tables
Hello,
I hope you are doing well. The first time I needed help, usually I was able to find what I was looking for - but now I don't even have an idea of what to start
I have two tables
main table:
| C1 | C2 | C3 | C4 | C5 | C6 | C7 | C8 |
| 3123 | FR | AD | KL | MA | SD | AS | WS |
| 3252 | FR | Dig | A | MA | SD | AS | WS |
| 3126 | AR | PS | P | CS | OL | DS | WF |
| 4534 | SR | Dig | C | CP | AS | CA | WT |
support table:
| Index | Col1 | Col2 | Col3 | Col4 | Col5 |
| 1 | Dig | A | 12 | ||
| 2 | Dig | C | 12 | ||
| 3 | PS | P | 36 | ||
| 4 | PS | T | 12 | ||
| 5 | FR | AD | KL | MA | 48 |
(empty means any value)
The result that I expect is to find values from the support table and in an additional column in the main table add the right value
| C1 | C2 | C3 | C4 | C5 | C6 | C7 | C8 | C9 |
| 3123 | FR | AD | KL | MA | SD | AS | WS | 48 |
| 3252 | FR | Dig | A | MA | SD | AS | WS | 12 |
| 3126 | AR | PS | P | CS | OL | DS | WF | 36 |
| 4534 | SR | Dig | C | CP | AS | CA | WT | 12 |
I'm helpless I hope you can help.
1 Reply
Hi, Konrad162
In fact, the current version of Power BI does not support this filtering rule, you can submit an idea for here and the product team will take note of such a need.Related Link: New tab (powerbi.com)
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
