Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

SUM UP Min Measure

Hello experts,  I have this data table. I want to return MIN of Lost Sales, SOH and SIT - If the earliest StockAvailDate is before end of current month => incluce SIT  - If the earliest StockAvail...
Need Help
Tips and Tricks
Tutorial Requests
Arpitb12's avatar
Arpitb12
Helper I
2 years ago

1.Why 0 ?

I think the issue with the first two lines returning 0 is because the calculation of Si_date is not filtering the 'Fact - SIT' table by individual 'ITEM_DESC' and 'StockAvailDate' conditions. To resolve this, you need to adjust the calculation to filter the 'Fact - SIT' table based on the corresponding 'ITEM_DESC' and 'StockAvailDate' conditions for each item individually.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    🤔i dont get this "the corresponding 'ITEM_DESC' and 'StockAvailDate' conditions for each item individually" can you please give me some advise?