topic Re: display penultimate application hour meter in DAX Commands and Tips

display penultimate application hour meter

Anonymous — Mon, 30 Jan 2023 02:02:33 GMT

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.

Re: display penultimate application hour meter

FreemanZ — Mon, 30 Jan 2023 02:51:58 GMT

hi Anonymous

try like:

Measure =

VAR _date = SELECTEDVALUE(TableName[Date])

RETURN

MAXX(

FILTER(

ALL(TableName),

TableName[Date]<_date

TableName[Hourmeter]

)

Re: display penultimate application hour meter

Anonymous — Thu, 02 Feb 2023 13:46:20 GMT

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