Forum Discussion
analyze last filtered data
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 penultim...
amitchandak
Super User
Super UserAnonymous , 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) )