Forum Discussion

09's avatar
09
Icon for Helper I rankHelper 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]
)

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

09 , Try like

 

minx(filter(values('BD 1'[Material]),[ECRT 4400 UNR]<>0), calculate( MIN('BD 1'[Date])))

  • 09's avatar
    09
    Icon for Helper I rankHelper I
    4 years ago

    Thanks for replying. I tried your formula but it gave me that result.