Forum Discussion
Solved
How to add these two columns?
Example.zip in dropbox 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 u...
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
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
That's PERFECT! Thank you so much! And a fast response.