Forum Discussion

matthewtjy's avatar
matthewtjy
Icon for Helper I rankHelper I
5 years ago
Solved

Getting MAX value IF 2 conditions are met

Hi, how do I go about to create a column "Max_Value_Of_Latest_Submit_Dt" where it would calculate the MAX Sales corresponding to the Latest_Submit_Dt for the particular Employee?   In excel I would...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Sorry,

    the above was for the calculated measure.

    I posted one more reply that is for the calculated column.

     

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, matthewtjy 

Pleaes try the below DAX measure.

 

Max Sales of Last Submit Date =
VAR lastsubmitdate =
MAX ( 'Table'[Latest_Submit_Dt] )
RETURN
CALCULATE (
MAX ( 'Table'[Sales] ),
ALLEXCEPT ( 'Table', 'Table'[Employee] ),
'Table'[Submit_Dt] = lastsubmitdate
)

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

  • matthewtjy's avatar
    matthewtjy
    Icon for Helper I rankHelper I
    5 years ago

    Hi i've tried to key in the DAX formula but no values appeared and there was no formula error also.

    Did I do something wrong?

    I used the formula
    Max Sales of Last Submit Date =
    VAR lastsubmitdate =
    MAX ( 'Table'[Latest_Submit_Dt] )
    RETURN
    CALCULATE (
    MAX ( 'Table'[Sales] ),
    ALLEXCEPT ( 'Table', 'Table'[Employee] ),
    'Table'[Submit_Dt] = lastsubmitdate
    )

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      5 years ago

      Sorry,

      the above was for the calculated measure.

      I posted one more reply that is for the calculated column.

       

       

       

      • matthewtjy's avatar
        matthewtjy
        Icon for Helper I rankHelper I
        5 years ago

        Thank you so much! Your solution is very helpful!