I need to filter all the records of Plan Id from the Estadisticas table; the expression accepts it in the condition, but recording it gives me an error. What am I doing wrong?
Thanks in advance for your reply.
Solved! Go to Solution.
I have no idea about your table schema. You can adopt the given expression as per your schema.
The slice expression shall return a Boolean value (TRUE/FALSE). Your ANY(FILTER(โฆ)) expression returns a Text value.
IN(
[Plan id],
SELECT(
Estadicticas[Plan id],
AND(
[Fecha] >= [THISROW].[Fecha inicial],
[Fecha] >= [_THISROW].[Fecha final]
)
)
)
Thanks for your reply, I tried the expression but it gives me this message; Could it be an error in the auxiliary table?
[image]
I have no idea about your table schema. You can adopt the given expression as per your schema.
Thank you very much, I solved it by redesigning the tables and using this expression
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |