Hi everyone.
I’d like to this but have difficulties to work out ;
Table1
Date A B C
*** 1 2 3
*** 1 2 3
*** 1 2 3
Action
Choose A, B or C by dropdown (completed)
Choose start date and end date (completed)
3 Sum up the chosen item ex. When I choose A, the answer is 3 ( When B, 6)
I already know SELECT(Table1[A], AND([Date] >= [_THISROW].[start].[Date] <= [_THISROW].[end])) and have searched many articles but no fruits.
If you give me a breakthrough, very helpful.
Solved! Go to Solution.
Like this:
SUM(
SWITCH(
[Choose A, B, or C],
"A",
SELECT(
Table1[A],
AND(
([Date] >= [_THISROW].[Start Date]),
([Date] <= [_THISROW].[End Date])
)
),
"B",
SELECT(
Table1[B],
AND(
([Date] >= [_THISROW].[Start Date]),
([Date] <= [_THISROW].[End Date])
)
),
...,
LIST()
)
)
See also:
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |