topic Re: How to create a calculated columns with date - the nearest date of occurrence in DAX Commands and Tips

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

Fiala — Tue, 09 Feb 2021 21:22:30 GMT

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

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

mahoneypat — Wed, 10 Feb 2021 00:05:44 GMT

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

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

Fiala — Wed, 10 Feb 2021 11:30:15 GMT

mahoneypat works great, thank you very much 🙂

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

Fiala — Sun, 13 Feb 2022 08:49:35 GMT

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