topic How to return a different value if the reference cell is blank in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-return-a-different-value-if-the-reference-cell-is-blank/m-p/4156947#M165186 <P>Hello,</P><P>&nbsp;</P><P>Looking for help to solve this issue.</P><P>My command is still returning "Overdue" when the Due Date column is blank. How can I only return Overdue if the Due Date is &gt; Today?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thank you</P><P>&nbsp;</P> Wed, 18 Sep 2024 13:29:16 GMT PeterVE95 2024-09-18T13:29:16Z How to return a different value if the reference cell is blank https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-return-a-different-value-if-the-reference-cell-is-blank/m-p/4156947#M165186 <P>Hello,</P><P>&nbsp;</P><P>Looking for help to solve this issue.</P><P>My command is still returning "Overdue" when the Due Date column is blank. How can I only return Overdue if the Due Date is &gt; Today?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thank you</P><P>&nbsp;</P> Wed, 18 Sep 2024 13:29:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-return-a-different-value-if-the-reference-cell-is-blank/m-p/4156947#M165186 PeterVE95 2024-09-18T13:29:16Z Re: How to return a different value if the reference cell is blank https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-return-a-different-value-if-the-reference-cell-is-blank/m-p/4156985#M165188 <P>Hi,</P> <P>&nbsp;</P> <P>You can try this</P> <P>&nbsp;</P> <P>OverdueStatus = <BR />IF(<BR />ISBLANK('YourTable'[Due Date]),<BR />BLANK(),<BR />IF(<BR />'YourTable'[Due Date] &lt; TODAY(),<BR />"Overdue",<BR />BLANK()<BR />)<BR />)</P> Wed, 18 Sep 2024 13:40:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-return-a-different-value-if-the-reference-cell-is-blank/m-p/4156985#M165188 Kaviraj11 2024-09-18T13:40:59Z Re: How to return a different value if the reference cell is blank https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-return-a-different-value-if-the-reference-cell-is-blank/m-p/4157284#M165201 <P>Thank you that worked!</P> Wed, 18 Sep 2024 15:09:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-return-a-different-value-if-the-reference-cell-is-blank/m-p/4157284#M165201 PeterVE95 2024-09-18T15:09:59Z