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.
I'm working on a Production Dashboard in Desktop to track 2 production schedules: Production A (Jan-May) and Production B (July-Dec).
Production techs will fulfil orders using the Schedule Targets. They can fulfil these targets using existing inventory when available. If inventory doesn't exist in their spec, they'll have to create inventory.
Production techs will update their Delivery excel worksheet when they have completed a part in their spec for their production schedule. A part cannot be consumed in Schedule A and Schedule B.
The following excel charts are updated frequently to track production and delivery status:
The following excel chart is updated twice a year by a manager at the end of a project:
The following excel charts are for reference only and do not need to be updated:
What I need help with:
I need to add 2 columns to the Production needed chart:
Is this possible with DAX, measures, or new columns?
Solved! Go to Solution.
Hi @mhunt ,
Thank you for the clear explanation, and the pbix. Build a measure that is the sum, and another for the count, then:
PTC = IF([Sum of Design]>[Count of Part],([Sum of Design]) - ([Count of Part]),0) PTR = IF([Sum of Design]>[Count of Part],[Count of Part],[Sum of Design])
Obviously these are for Schedule A
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @mhunt ,
Thank you for the clear explanation, and the pbix. Build a measure that is the sum, and another for the count, then:
PTC = IF([Sum of Design]>[Count of Part],([Sum of Design]) - ([Count of Part]),0) PTR = IF([Sum of Design]>[Count of Part],[Count of Part],[Sum of Design])
Obviously these are for Schedule A
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
That's PERFECT! Thank you so much! And a fast response.
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |