Find most recent date

[jwi1]

Hi all,

I am looking for a solution to calculate the most recent_ready_date if the LOCATION and the PARTNUMBER_SUP is the same

In the last column I mentioned the outcome of the calculation.

Thanks for your help!

John

location	ready_dat	partnumber_sup	most_recent_ready_date
City	12/28/2021	AM171081201	12/28/2021
City	9/23/2021	AM171081201	12/28/2021
Holland	11/12/2021	120039501SV	11/12/2021
Holland	7/20/2021	120039501SV	11/12/2021
America	12/27/2021	AM171081201	12/27/2021
America	6/3/2021	AM171081201	12/27/2021

[amitchandak · Accepted solution]

@jwi1 , Try a new column like

maxx(filter(Table, [location] = earlier([location]) && [PARTNUMBER_SUP] = earlier([PARTNUMBER_SUP])), [ready_dat])

a nw measure like

maxx(filter(allselected(Table), table[location] = max(table[location]) && table[PARTNUMBER_SUP] = max(table[PARTNUMBER_SUP])), table[ready_dat])

[Jihwan_Kim · Accepted solution]

most recent ready date: =
IF (
ISINSCOPE ( Data[location] ),
IF ( COUNTROWS ( Data ) > 1, MAX ( Data[ready_dat] ) )
)

[amitchandak · Accepted solution]

@jwi1 , Try a new column like

maxx(filter(Table, [location] = earlier([location]) && [PARTNUMBER_SUP] = earlier([PARTNUMBER_SUP])), [ready_dat])

a nw measure like

maxx(filter(allselected(Table), table[location] = max(table[location]) && table[PARTNUMBER_SUP] = max(table[PARTNUMBER_SUP])), table[ready_dat])