I’m trying to make a condition in DAX, but without success. Basically, what I need is:

If the current date column is different from the selected date, add the Delivery time column day [date] with the subsequent row.

VAR CurrentDate = MAX(Table1[Date]) VAR NextDate = MINX(FILTER(Table1, Table1[Date] > CurrentDate),Table1[Date]) RETURN IF(CurrentDate <> NextDate, SUMX(FILTER(Table1, Table1[Date] = NextData), Table1[TOTAL DELIVERY TIME PER DAY]), 0)

I tried to use this, but it didn’t return any value.
Please, I need help. I’m just a learner

VAR CurrentDate = MAX(Table1[Date]) VAR NextDate = MINX(FILTER(Table1, Table1[Date] > CurrentDate),Table1[Date]) RETURN IF(CurrentDate <> NextDate, SUMX(FILTER(Table1, Table1[Date] = NextData), Table1[TOTAL DELIVERY TIME PER DAY]), 0)

I tried to use this, but it didn’t return any value.