Forum Discussion
Solved
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...
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.
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.
hey WIll, is it possible for you to share the data, just shoot an excel file and will take a look. I believe you are using PBIX file which I sent to you