Forum Discussion

iiomarioii's avatar
iiomarioii
Icon for Helper II rankHelper II
6 years ago
Solved

Date when value is negative

Hi guys,    this is my table:  Table1: Date Item number Quantity (Measure)  01.01.2020   1      10 02.01.2020   1    5 03.01.2020   1   0 04.01.2020   1  -5 01.01.2020...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi iiomarioii,

     

    Try add filter to the formula.

    positive =
IF (
    'Gesamt2'[Date]
        = CALCULATE (
            MAX ( 'Date'[Date] ),
            FILTER ( ALLEXCEPT ( Tablle1, 'Tablle1'[Artikelnummer] ), [total] >= 0 )
        ),
    'Gesamt2'[Date],
    BLANK ()
)

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.