Error DAX comparison operations do not support comparing values of type Text with values of type Num

[Anonymous]

Hi all,

Im new here and I'm having this issue DAX comparison operations do not support comparing values of type Text with values of type Number. This is the DAX I'm trying to use:

LY_MARS: = CALCULATE([Venta],FILTER(ALL('DATE'),'DATE'[Periodo]<=MAX('DATE'[Periodo]) && 'DATE'[AÑO]=MAX('DATE'[AÑO])-1))

This basically shows the previouse value of a filtered year as shown below:

Values 

Sum of Value	2,121,200
LY_MARS	10,524,293

Thanks in advance,

Julian C.

[Anonymous]

Please learn how to correctly use time-intel functions:

https://www.sqlbi.com/tv/time-intelligence-in-microsoft-power-bi/

Best
D