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.
Hi community,
We currently sell sets which are a combination of multiple components.
For example a Farm Set (item code 12345) is made of three components: cows (item code 12344), chicken (item code 12343) and pigs (item code 12342).
I would like to have a rule that shows that the Farm Set is out of stock if one of the three components have a stock less than 3 for example.
Does anyone know a formula that could help me to achieve that?
I have a table that looks like this:
SET NAME | SET CODE | COMPONENT CODE | COMPONENT NAME | COMPONENT STOCK |
FARM SET | 12345 | 12344 | COWS | 5500 |
FARM SET | 12345 | 12343 | CHICKEN | 1870 |
FARM SET | 12345 | 12342 | PIGS | 1251 |
Thanks!
Solved! Go to Solution.
@marianamarques,
Please check the DAX in the PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1Nok1jyeIy6V0Y47bBF
Regards,
Lydia
@marianamarques,
Please check the DAX in the PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1Nok1jyeIy6V0Y47bBF
Regards,
Lydia
Thanks a lot Lydia! It works!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |