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.

Solved Solved
0 5 208
1 ACCEPTED SOLUTION

I have no idea about your table schema. You can adopt the given expression as per your schema.

View solution in original post

5 REPLIES 5

LeventK
Participant V

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

Steve
Participant V
Top Labels in this Space