Forum Discussion
Williamwil88
9 years agoFrequent Visitor
Formula Error
I am attempting to calculate a value called _QPPM using two different sources. The value is derived from the number of identified failure divided by the number of shipments for the month multiplied b...
- 9 years ago
if possible, can you put sample data form both tables in a excel sheet and send it over, i will put together somethign quickly and share pbix file wiht you, it will be much easier.
I don't see there is any dedicated calendar table and that seems to be first missing part in all this.
Williamwil88
9 years agoFrequent Visitor
Williamwil88
9 years agoFrequent Visitor
It looks like there is a similar issue for shipped qty. There should be a shipped quantity every month. I have months where there is no shipment quantity.