Forum Discussion
Filtering the data in 1st table based on 2nd table
Hi Community,
There are two tables,
The output from the 2nd table should be filtered based on 1st table values.
1st table :
| C | C1 | C2 | C3 |
| S | A | T | U |
2nd table:
| C | C1 | C2 | C3 |
| A | A | T | U |
| B | A | T | U |
| C | A | S | T |
| D | B | B | D |
| E | C | X | V |
Here, Columns C1, C2 and C3 from the 1st table need to be filtered in the 2nd table and output should be all the columns in the 2nd table.
Output:
| C | C1 | C2 | C3 |
| A | A | T | U |
| B | A | T | U |
Kindly help by through DAX.
Regards,
Vineetha.
- So, I am thinking that you might want to create a key column in both tables that is essentially:
Key Column = [C1] & [C2] & [C3]
Create a relationship between the tables based on the key column. Then you should be good to go.
1 Reply
- Greg_Deckler
Community Champion
So, I am thinking that you might want to create a key column in both tables that is essentially:
Key Column = [C1] & [C2] & [C3]
Create a relationship between the tables based on the key column. Then you should be good to go.