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.
Rhayan Bembem is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.