analyze last filtered data

[Anonymous]

If I filter for example 04/14/2022 to 04/17/2022 it should show me the last consumption on 04/15/2022 and the penultimate on 10/01/2022 but when performing such a filter it does not show the penultimate application of 10/ 01/2022

[amitchandak]

@Anonymous , Try lastnonblankvalue

lastnonblankvalu(Table[Date], sum(Values))

or

Measure =

var _max = maxx(allselected(Table), Table[Date]) //Assume joined date table is giving slicer values

return

calculate(sum(Table[Value]). Filter('Date', 'Date'[Date] =_max) )