Forum Discussion

iiomarioii's avatar
iiomarioii
Helper 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.

V-lianl-msft's avatar
V-lianl-msft
Community Support
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.

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi iiomarioii ,

 

Is this problem sloved?
If not, please let me know.

 

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