Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I want to get product names related to the same IDs between tables createing a measure or calculated column on the TableA and display them on a slicer.
TableA:
Date | IDa | ProductName |
2021/6/1 | 1 | book |
2021/6/2 | 2 | note |
2021/6/3 | 3 | pen |
TableB:
Date | IDb | KW |
2021/6/4 | 4 | 123565 |
2021/6/5 | 2 | 467234 |
2021/6/6 | 5 | 3423 |
The relationship between the tables is IDa (many) to IDb (one).
I try a measure and calculated column to do this, but I can't get correct values due to error.
Any idea, please?
Thanks,
Vladi
Solved! Go to Solution.
@PbiCeo
You can add a Calculated Column in Table B with the following formula:
Name = RELATED( TableA[Product name] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@PbiCeo
You can add a Calculated Column in Table B with the following formula:
Name = RELATED( TableA[Product name] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |