Select a value based on max date

Hi Miguel_Angel ,

I think you can use the max() to get the value. For example:

measure = calculate(max(value),filter(all(termination date, register date),termination date > max(register date) && entry date < max(register date)))

and create a slicer for register date, and use the equal or less than mode.

Please try.

Aiolos Zhao

Hi Miguel_Angel 

Please create another table using 

new table=Values(table[register date])

This new table has no relationship with others.

Then add [register date] from "new table" into a slicer,

Create a measure

max date=max('new table'[register date])

To only show rows which meets the rule.

create a measure

meet_rule =
IF (
    MAX ( table[Entry date] ) < [max date]
        && (
            MAX ( table[Termination date] ) > [max date]
                || MAX ( table[Termination date] ) = BLANK ()
        ),
    "should show",
    "not show"
)

Then add this measure into a table visual level filter, apply the filter to show rows you'd like.

If you want to sum the values which meets rules.

Create a measure

sum =
CALCULATE (
    SUM ( [values] ),
    FILTER (
        table,
        table[Entry date] < [max date]
            && (
                table[Termination date] > [max date]
                    || table[Termination date] = BLANK ()
            )
    )
)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.