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.
hey Will, can you send the data int he same format which you sent me yesterday, your new sheet has new columns, if data is in same format, it will be quick for me to take a look what is going on.
I've used the same report export from the database. I've just confirmed the columns are the same as the previous spreadsheet. Can you identify the new columns? I may have overlooked something.