Error en la expresion

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.

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]
		)
	)
)
		
1 Like

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.

1 Like
1 Like

Thank you very much, I solved it by redesigning the tables and using this expression

1 Like