Hi All,
I have a delivery column with before and after text selection options. I would like to use these two as criteria to sum all values from the latest “before delivery” up to the latest “after delivery”.
like this table: from the most recent "Before Delivery to the Most Recent “After Delivery”= 111
thanks
Solved! Go to Solution.
Try:
SUM(
SELECT(
MyTable[Sales],
AND(
(
[Date] >= MAX(
SELECT(
MyTable[Date],
("Before Dlivery" = [Before or After Delivery])
)
)
),
(
[Date] <= MAX(
SELECT(
MyTable[Date],
("After Dlivery" = [Before or After Delivery])
)
)
)
)
)
)
Try:
SUM(
SELECT(
MyTable[Sales],
AND(
(
[Date] >= MAX(
SELECT(
MyTable[Date],
("Before Dlivery" = [Before or After Delivery])
)
)
),
(
[Date] <= MAX(
SELECT(
MyTable[Date],
("After Dlivery" = [Before or After Delivery])
)
)
)
)
)
)
Hi Steve,
Works great! Thanks
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |