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.

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
6 years ago

iiomarioii 

Try this as new column:

Positive = 
IF(
    [Date] = 
    CALCULATE(
        MAX(Table1[Date]),
        ALLEXCEPT(Table1,Table1[Item number]),
        Table1[Quantity]>0
    ), 
    [Date],
    BLANK()
)

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn


iiomarioii's avatar
iiomarioii
Icon for Helper II rankHelper II
6 years ago
 
Positive =
IF(
[Date] =
CALCULATE(
MAX('Date'[Date]),
ALLEXCEPT(Table1,Table1[item number]),
[Quantity]>0
),
[Date],
BLANK()
)  
 
Thank you! I get this error: 
A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.