Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have the two table Global parameter and Remark2(local) . i am trying to get BOM value from Remark2(BOM) in Global parameter table using the below
Global Parameter :
ItemCode Rev Outer
FA031375.12 11 Thenna
FA031375.13 9 Thenna
Remark2 (Local)
ItemCode Rev BOMTEXT(Parameter BOM)
FA031375.12 11 Thenna
FA031375.13 9 Thenna
Execpted output:
ItemCode Rev Outer BOMTEXT
FA031375.12 11 Thenna Thenna
FA031375.13 9 Thenna Thenna
Looking for support . thanks in advance .
Solved! Go to Solution.
Hi,
You can use dax expressions below.
But in general Your model is good example which shows that usage of many-to-many relationships isn't good idea.
So many-to-many is the main problem here.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
19 | |
17 | |
12 | |
9 | |
9 |