topic multiple if condition with format in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/multiple-if-condition-with-format/m-p/818223#M5503 <P>i trying to create the column that we will provide me 1 or 0 based on this condition.</P><DIV><DIV><SPAN>Column = </SPAN></DIV><DIV><SPAN>IF(</SPAN></DIV><DIV><SPAN>FORMAT(Table1[Dia],"General Number") &gt; 90 &lt; 100,</SPAN></DIV><DIV><SPAN>IF(</SPAN></DIV><DIV><SPAN>FORMAT(Table1[ETA],"Fixed") &lt;10 &gt;0,</SPAN></DIV><DIV><DIV><SPAN>IF(</SPAN></DIV><DIV><SPAN>Table1[DATETIME] = MAX(Table1[DATETIME] ),</SPAN></DIV></DIV><DIV><SPAN>1,0))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>but getting this error.<img /></SPAN></DIV></DIV> Tue, 15 Oct 2019 09:23:00 GMT alikhan_3 2019-10-15T09:23:00Z multiple if condition with format https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/multiple-if-condition-with-format/m-p/818223#M5503 <P>i trying to create the column that we will provide me 1 or 0 based on this condition.</P><DIV><DIV><SPAN>Column = </SPAN></DIV><DIV><SPAN>IF(</SPAN></DIV><DIV><SPAN>FORMAT(Table1[Dia],"General Number") &gt; 90 &lt; 100,</SPAN></DIV><DIV><SPAN>IF(</SPAN></DIV><DIV><SPAN>FORMAT(Table1[ETA],"Fixed") &lt;10 &gt;0,</SPAN></DIV><DIV><DIV><SPAN>IF(</SPAN></DIV><DIV><SPAN>Table1[DATETIME] = MAX(Table1[DATETIME] ),</SPAN></DIV></DIV><DIV><SPAN>1,0))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>but getting this error.<img /></SPAN></DIV></DIV> Tue, 15 Oct 2019 09:23:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/multiple-if-condition-with-format/m-p/818223#M5503 alikhan_3 2019-10-15T09:23:00Z Re: multiple if condition with format https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/multiple-if-condition-with-format/m-p/818769#M5518 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="123949" data-lia-user-login="alikhan_3" class="lia-mention lia-mention-user">alikhan_3</a>&nbsp;</P><P>Are you sure you need to use format for Dia andETA columns? it looks like its already numbers</P> Tue, 15 Oct 2019 19:20:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/multiple-if-condition-with-format/m-p/818769#M5518 az38 2019-10-15T19:20:18Z