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. 

Williamwil88's avatar
Williamwil88
Frequent Visitor
9 years ago

The Issue Date slicer corresponds to the table data. This may be part of the issue. The date field in the zMerps table corresponding to the shipping quantity is SH_ShipDate. The data table visual only reflects information from the NCMR query accept for the _QPPM measurement which pulls shipment quantity from the zMerps query.  Below, I've provided a snapshot of my values and filters sidebar for the NCMR table.

 

 

NCMR Query Fields

 

 

zMerps

parry2k's avatar
parry2k
Super User
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.