Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 penultimate application of 10/ 01/2022

 

 

CODE
DAX
DAX Calculation

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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) )