display penultimate application hour meter

[Anonymous]

Hi misters.

I have a problem that I have already resorted to different measures, I used max, keep filters, created virtual tables, relashionship and I could not solve it when filtering for example 11/01/2022 the penultimate hourmeter needs to be displayed, the problem happens if I filter 11/01 /2022 the hourmeter for that date only is displayed.

[FreemanZ]

hi @Anonymous 

try like:

Measure =

VAR _date = SELECTEDVALUE(TableName[Date])

RETURN

MAXX(

    FILTER(

        ALL(TableName),

       TableName[Date]<_date

    ),

   TableName[Hourmeter]

)

[Anonymous]

the report still has failures, if I filter only 12/30 it doesn't return me the correct value.