I have two tables like below
Daily updating table
Only for report - ( editing the same row)
I want to create a slice table C with the date of table A based on table B criteria
like this
Any one please suggest me a solution for this
Hello-
I’m not sure if I got it correctly but based on your screenshots. You want to filter the data in Table A based on the columns in Table B. If yes, please test the formula below. But I haven’t tested it in the app editor. Feel free to give feedback in case you encountered any errors.
AND(
[Date] >=
ANY(
SELECT(
Table B[From],
TRUE
)
),
[Date] <=
ANY(
SELECT(
Table B[To],
TRUE
)
),
[Customer] =
ANY(
SELECT(
Table B[Customer],
TRUE
)
)
)
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |