https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-function-HELP/m-p/2628679#M76804 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="389924" data-lia-user-login="Kayla2501" class="lia-mention lia-mention-user">Kayla2501</a> . Confidence back is numeric, so in place on "" use 0 or blank() </P> <P>&nbsp;</P> <P>Also, the measure will not work correctly in the calculated column, if you are using one</P> Sat, 09 Jul 2022 07:33:22 GMT amitchandak 2022-07-09T07:33:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-function-HELP/m-p/2628652#M76799 <P>Hi All,&nbsp;</P><P>&nbsp;</P><P>I want to add a new column that is basically if Status date equals current then give the value in confidence factor if not than blank. (current status date is 30 June 2022)&nbsp;</P><P>&nbsp;</P><P>I have tried this and it doesnt work and not sure why?</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Sat, 09 Jul 2022 06:19:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-function-HELP/m-p/2628652#M76799 Kayla2501 2022-07-09T06:19:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-function-HELP/m-p/2628679#M76804 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="389924" data-lia-user-login="Kayla2501" class="lia-mention lia-mention-user">Kayla2501</a> . Confidence back is numeric, so in place on "" use 0 or blank() </P> <P>&nbsp;</P> <P>Also, the measure will not work correctly in the calculated column, if you are using one</P> Sat, 09 Jul 2022 07:33:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-function-HELP/m-p/2628679#M76804 amitchandak 2022-07-09T07:33:22Z