Forum Discussion
Solved
Date math problem: if (ExpectedDate<=date, QTY, 0)
I have a standard Date table, Sales table, and Incoming table. The Sales Table and Incoming Table both have QTY, and a Sales_Date for sales, and an Expected_Date for Incoming. I plot daily sales...
Try this slight modification...
Cumulative Incoming = CALCULATE( SUM(Incoming[Incoming Qty]) , FILTER( ALLSELECTED('Incoming'), 'Incoming'[Incoming Date]<=MAX('Dates'[Date]) ) )
Try this slight modification...
Cumulative Incoming = CALCULATE(
SUM(Incoming[Incoming Qty]) ,
FILTER(
ALLSELECTED('Incoming'),
'Incoming'[Incoming Date]<=MAX('Dates'[Date])
)
)
That seems to work perfectly. Thank you very much!