https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/One-year-later-and-an-empty-field/m-p/3635045#M140618 <P>Hi, my problem is a little bit complicated. I want to create a a field, which only shows up when two conditions are fulfilled. I have two relevant date tables for that. My first date table is [Date Dispatch] and my second [Date Estimated]. I want that the new field with a warning signal (and maybe the option to click on it to see all other informations) should pop up, when its one year after [Date Dispatch] AND [Date Estimated] is empty. I´ve tried it with If function but that doesn´t work. Maybe anybody could help me or just have an idea how to solve it. Thanks in advance.</P> Fri, 12 Jan 2024 05:58:37 GMT Anonymous 2024-01-12T05:58:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/One-year-later-and-an-empty-field/m-p/3635045#M140618 <P>Hi, my problem is a little bit complicated. I want to create a a field, which only shows up when two conditions are fulfilled. I have two relevant date tables for that. My first date table is [Date Dispatch] and my second [Date Estimated]. I want that the new field with a warning signal (and maybe the option to click on it to see all other informations) should pop up, when its one year after [Date Dispatch] AND [Date Estimated] is empty. I´ve tried it with If function but that doesn´t work. Maybe anybody could help me or just have an idea how to solve it. Thanks in advance.</P> Fri, 12 Jan 2024 05:58:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/One-year-later-and-an-empty-field/m-p/3635045#M140618 Anonymous 2024-01-12T05:58:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/One-year-later-and-an-empty-field/m-p/3635095#M140624 <P>Anonymous</LI-USER>&nbsp; You can create a calculated column which will show warning signal.&nbsp;<BR /><BR />Warning Signal = IF(<BR />DATEDIFF(Table[Date Dispatch], TODAY(), DAY) &gt;= 365 &amp;&amp; ISBLANK(Table[Date Estimated]),<BR />"<SPAN>Warning</SPAN>",<BR />BLANK()<BR />)</P> Fri, 12 Jan 2024 06:42:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/One-year-later-and-an-empty-field/m-p/3635095#M140624 saurabhtd 2024-01-12T06:42:30Z