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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Filter Max time per day

Krkrang_0-1657097578381.png

How can I filter the day and night per day to only show the latest data. I have tried filter by last min/hr but it does not work for my data.

 

The data that comes in from the source only includes personel that is present. The Date coming in because of it comes from the powerapp, each row is populated at different time, so i have rounded it to the nearest 5 minutes since one submittion takes less than 5 minutes. 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

Add a measure like:

flag =
VAR _maxtime =
    CALCULATE (
        LASTNONBLANK ( 'Table'[DateTime], 1 ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Date] = MAX ( 'Table'[Date] )
                && 'Table'[Name] = MAX ( 'Table'[Name] )
        )
    )
RETURN
    IF ( MAX ( 'Table'[DateTime] ) = _maxtime, 1, 0 )

Then apply this measure to the table filter pane:

veasonfmsft_0-1657525432223.png

Best Regards,
Community Support Team _ Eason

 

View solution in original post

1 REPLY 1
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

Add a measure like:

flag =
VAR _maxtime =
    CALCULATE (
        LASTNONBLANK ( 'Table'[DateTime], 1 ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Date] = MAX ( 'Table'[Date] )
                && 'Table'[Name] = MAX ( 'Table'[Name] )
        )
    )
RETURN
    IF ( MAX ( 'Table'[DateTime] ) = _maxtime, 1, 0 )

Then apply this measure to the table filter pane:

veasonfmsft_0-1657525432223.png

Best Regards,
Community Support Team _ Eason

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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