DAX comparison operations do not support comparing values of type True/False with values of type Int

Question

Hello.&nbsp;May anyone help me to sort out "DAX comparison operations do not support comparing values of type True/False with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values." error?&nbsp;I created the following column to show the current month and the last month on blank:&nbsp;current_last_month_blank = IF(OR(VALUE(CONCATENATE(YEAR(MAX(Calendario_pedido[Order_day])); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FORMAT(MONTH(MAX(Calendario_pedido[Order_day])); "00")));VALUE(MAXX( Calendario_pedido;CONCATENATE(YEAR(DATEADD(Calendario_pedido[Order_day];-1;MONTH));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FORMAT(MONTH(DATEADD(Calendario_pedido[Order_day];-1;MONTH));"00")))))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = Calendario_pedido[year_month_order];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BLANK(); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Calendario_pedido[year_month_order])&nbsp;&nbsp;&nbsp;Thanks

ibarrau · Accepted Answer

Hi there. The thin is you have to ask twice in the OR statement and not at the end. It need from you to return a true false on each argument of the function. Check this correction out:
IF(
	OR(
		VALUE(CONCATENATE(YEAR(MAX(Calendario_pedido[Order_day]));
			FORMAT(MONTH(MAX(Calendario_pedido[Order_day])); "00"))) = Calendario_pedido[year_month_order];
		VALUE(MAXX( Calendario_pedido;CONCATENATE(YEAR(DATEADD(Calendario_pedido[Order_day];-1;MONTH));
			FORMAT(MONTH(DATEADD(Calendario_pedido[Order_day];-1;MONTH));"00"))))= Calendario_pedido[year_month_order]
	)
	; BLANK()
	; Calendario_pedido[year_month_order]
)
There you have two times the condition.
&nbsp;
Hope this works
Regards

Forum Discussion

DAX comparison operations do not support comparing values of type True/False with values of type Int

2 Replies

Related content

True/False, if statement

DAX Involving TRUE/FALSE Column

True/False Measure

True False Statement Help

The True/False expression does not specify a column. Each True/False expressions used as a table