Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter Max time per day

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. 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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:

    Best Regards,
    Community Support Team _ Eason

     

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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:

    Best Regards,
    Community Support Team _ Eason