Forum Discussion
matthewtjy
Helper I
Helper IGetting 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...
Sorry,
the above was for the calculated measure.
I posted one more reply that is for the calculated column.
matthewtjyHelper I
Helper IHi 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
Super User
Super UserSorry,
the above was for the calculated measure.
I posted one more reply that is for the calculated column.
- matthewtjy
Thank you so much! Your solution is very helpful!