Forum Discussion
Formula Error
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.
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
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 you are correct. I needed the dedicated calendar; however, the sum value for RejectQty is incorrect. For example, using my data the number of failures for the month of September 2016 should be 363. The number of failures shown is 97.
The calculation used is as follows:
_RejectQty = SUM(NCMR[Initial Qty Reject])
My visualization of the data:
Can you share row level data for Sep 2016? Do you see sum of other months is correct?