Select Next Date in table after First Date in slider

[Annemie19]

Hi There, 

I have to create a measure that selects the first date in a column (measurementnextdate) that is after the the first date in a slider (AA MinDate) for each Covenant ID.

So if if the date in the slider is 30/09/2020 I want to only return the rows marked in red:

This is the dax that I used:

AA Next MDate =

VAR FirstMeasurementDate = [AA MinDate]

VAR DatesGreaterThanValueDate =

FILTER (

SUMMARIZE (VwCovenant,VwCovenant[Measurementnextdate], VwCovenant[CovenantID]),

VwCovenant[Measurementnextdate] > FirstMeasurementDate

)

VAR NextImmediateDate =

MINX ( DatesGreaterThanValueDate, VwCovenant[Measurementnextdate] )

RETURN

NextImmediateDate

But it is not working. 

[dedelman_clng]

Your code and data don't really match, but the solution could be simple.  Once you do a "SUMMARIZE", if you refer to that table you should be able to just refer to the column itself:

AA Next MDate =
VAR FirstMeasurementDate = [AA MinDate]
VAR DatesGreaterThanValueDate =
    FILTER (
        SUMMARIZE (
            VwCovenant,
            VwCovenant[Measurementnextdate],
            VwCovenant[CovenantID]
        ),
        [Measurementnextdate] > FirstMeasurementDate  //Code change 1
    )
VAR NextImmediateDate =
    MINX ( DatesGreaterThanValueDate, [Measurementnextdate] )  //Code change 2
RETURN
    NextImmediateDate

If this doesn't work, can you share your pbix wit sensitive data removed? Otherwise please define [AA Min Date], make sure your data matches up with your code, and provide data in a format that can be easily copied.

Hope this helps

David