Forum Discussion

Annemie19's avatar
Annemie19
Icon for Helper II rankHelper II
6 years ago
Solved

Select first date in table after certain date

Hi there,    I have a date specified by the user (AA Last Value Date), I need to write a measure to select the first projection date (ProjEndDate_Date) in another table after the value date. For in...
  • AntrikshSharma's avatar
    AntrikshSharma
    6 years ago

    Annemie19  Try this:

    AA Last Proj_date =
VAR LastValueDate =
    SELECTEDVALUE ( CashProjection[AA Last value date] )
VAR DatesGreaterThanValueDate =
    FILTER (
        SUMMARIZE (
            CashProjection,
            CashProjection[ProjEndDate_Date],
            CashProjection[AA Last value date]
        ),
        CashProjection[ProjEndDate_Date] > LastValueDate
    )
VAR NextImmediateDate =
    MINX ( DatesGreaterThanValueDate, CashProjection[ProjEndDate_Date] )
RETURN
    NextImmediateDate
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Annemie19 , In table 2, you can have a new column

 

minx(filter(table1, table1[user] =table2[user]), table1[projenddate_date])

minx(filter(table1, table1[user] ="AA"), table1[projenddate_date])

minx(table1, table1[projenddate_date])