Forum Discussion

Williamwil88's avatar
Williamwil88
Frequent Visitor
9 years ago
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...
Need Help
  • parry2k's avatar
    parry2k
    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. 

parry2k's avatar
parry2k
Super User
9 years ago

Can you share row level data for Sep 2016? Do you see sum of other months is correct?

  • Williamwil88's avatar
    Williamwil88
    Frequent Visitor
    9 years ago

    The sum for all months is incorrect. I've sent you a link to the data for Sept. 2016.

     

    Thanks

    • parry2k's avatar
      parry2k
      Super User
      9 years ago

      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. 

      • Williamwil88's avatar
        Williamwil88
        Frequent Visitor
        9 years ago

        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.