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 inc...
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

     

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