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!