Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jeanso
Frequent Visitor

display penultimate application hour meter

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.

 

 

jeanso_1-1675044073406.png

 

2 REPLIES 2
FreemanZ
Super User
Super User

hi @jeanso 

try like:

Measure =
VAR _date = SELECTEDVALUE(TableName[Date])
RETURN
MAXX(
    FILTER(
        ALL(TableName),
       TableName[Date]<_date
    ),
   TableName[Hourmeter]
)

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors