Forum Discussion

09's avatar
09
Helper I
4 years ago
Solved

Return the discrepancy date per material

Hello all, I'm trying to make a DAX measure that returns the first date a discrepancy happens for each material in a pivot table but the formula that i've created didn't give me the right result: CA...
DAX Calculation
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi 09 

    you may try

     

    Measure1 :=
MINX (
    FILTER (
        CALCULATETABLE ( 'BD 1', ALLEXCEPT ( 'BD 1', 'BD 1'[Material] ) ),
        [ECRT 4400 UNR] <> 0
    ),
    'BD 1'[Date]
)

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi 09 

you may try

 

Measure1 :=
MINX (
    FILTER (
        CALCULATETABLE ( 'BD 1', ALLEXCEPT ( 'BD 1', 'BD 1'[Material] ) ),
        [ECRT 4400 UNR] <> 0
    ),
    'BD 1'[Date]
)

 

09's avatar
09
Helper I
4 years ago

Thank you. It works perfectly.