Latest value have to pick based on end date field.

[rajendraongole1]

Hi,

Need help as per below table information. i have to pick the latest value (%) based on the end date . some of the end dates are availables with blank though i have to refer the value with latest value showing up in below table.

89% have to show in card vix.

Please suggest.

End Date                  Completion

4/12/2019	100%
6/22/2019	90%
6/20/2021	89%
12/13/2021

[v-lionel-msft · Accepted solution]

Hi @rajendraongole1 ,

Is this what you want? Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@rajendraongole1 , Try a new measure. If Completion is a measure

lastnonblankvalue(table[End Date],[Completion])

if it is a column

lastnonblankvalue(table[End Date],max(Table[Completion]))

[rajendraongole1]

thanks for your reply amit, 

I have tried both the options , it is not picking up the right value. as in last end date we have blank in % completion so reported with 0. but expected to pick the value of 89% which is other than blank information.

any suggestions. pls 

[rajendraongole1]

As per the end date, it has to take the end date before value in completion.

Pls suggest.