¿Alguien me puede decir por qué esta mal esta función?

[94veiga]

Descuento CP = SWITCH(TRUE(),

'Facturas + CN'[IdTipoLiq] = "CP" & 'Facturas + CN'[Año Factura] = "2019", 0.9,

'Facturas + CN'[IdTipoLiq] = "CP" & 'Facturas + CN'[Año Factura] = "2020", 0.9,

'Facturas + CN'[IdTipoLiq] = "CP" & 'Facturas + CN'[Año Factura] = "2018", 0.7,

'Facturas + CN'[IdTipoLiq] = "CP" & 'Facturas + CN'[Año Factura] = "2017", 0.7,

1)

[amitchandak]

@94veiga , seems fine a new column. What is the issue you are getting.

[94veiga]

It gives me this error:

DAX comparison operations do not support comparison values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

Thanks a lot!

[v-lionel-msft · Accepted solution]

Hi @94veiga ,

Your formula uses the wrong operator "&&".

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.