How to create a calculated columns with date - the nearest date of occurrence

[Fiala]

Hi, is it possible to create a calculated column with the date of the next occurrence of the value according to the picture below?

Thank you

[mahoneypat · Accepted solution]

Please try this column expression

Next Date =
VAR vThisDate = Table[Date]
VAR vNextDate =
    CALCULATE (
        MIN ( Table[Date] ),
        ALLEXCEPT (
            Table,
            Table[Value]
        ),
        Table[Date] > vThisDate
    )
RETURN
    vNextDate

Pat

[Fiala]

Hellou @mahoneypat @, can you please help me again? I need almost the same. but I need to create a measure instead of calculated column. I need to find out the nearest date of occurence

I create a virtual table CD_MSISDN = value):

var t1 = ADDCOLUMNS(GROUPBY(Query1,Query1[value],Query1[TS_ENTERED_QUEUE]),"next contact",next_date)

looks like:

I don´t know how to create Next contact column.

Thank you

[Fiala · Accepted solution]

@mahoneypat works great, thank you very much 🙂

[mahoneypat · Accepted solution]

Please try this column expression

Next Date =
VAR vThisDate = Table[Date]
VAR vNextDate =
    CALCULATE (
        MIN ( Table[Date] ),
        ALLEXCEPT (
            Table,
            Table[Value]
        ),
        Table[Date] > vThisDate
    )
RETURN
    vNextDate

Pat