Trying to find out max date with condition

[Sharmaa]

Hi Everyone 

I am trying to find out the max date based on two conditions,

i have 5 columns mention below:
as a result what i am trying to achieve is "Max date" for koromiko based on "Jump Number" where i want that system gives the Max date based on jump number "2". 

any help would be appreciated.

thanks 

[Mahesh0016]

@Sharmaa Please Try Below Code
Measure =
MAXX(filter(Table, Table[Jump Number]=2),Table[Date])
####################################################
Measure 2 =
calculate(Max(Table[Date]),allexcept(Table, Table[Jump Number]))

@Sharmaa If this post helps, then please consider Accept it as the solution to help the other members find it more quickly, THANK YOU!!

[Sharmaa]

Hi Mahesh 
thanks for your reply, but as you can see there is two jump number, and what i want that system pick the maxx date first with jump number 2 and if there is no jump number 2 then it's pick the jump number 1.

let me know if that make sense.

thanks 

[Mahesh0016]

@Sharmaa Please Try Below Code.
MEASURE 3=
VAR X = calculate(Max(Table[Date]),allexcept(Table, Table[Jump Number])) /
VAR X = MAXX(filter(Table, Table[Jump Number]=2),Table[Date])
VAR Y =calculate(Max(Table[Date]),Table[Jump Number]<MAX(Table[Jump Number]))
RETURN
IF(isblank(Table[Date]),Y,X)

@Sharmaa If this post helps, then please consider Accept it as the solution to help the other members find it more quickly, THANK YOU!!