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

Question

Hi all,&nbsp;Im new here and I'm having this issue&nbsp;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]&lt;=MAX('DATE'[Periodo]) &amp;&amp; 'DATE'[AÑO]=MAX('DATE'[AÑO])-1))This basically shows the previouse value of a filtered year as shown below:Values&nbsp;Sum of Value2,121,200LY_MARS10,524,293Thanks in advance,Julian C.&nbsp;&nbsp;

anonymous · Answer

Please learn how to correctly use time-intel functions:https://www.sqlbi.com/tv/time-intelligence-in-microsoft-power-bi/BestD

Forum Discussion

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

1 Reply

Related content

Text comparison (LIKE operator)

Comparison Chart

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

BI Tools Comparison

DAX Comparison operators

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