topic My Date Calculation is showing blank all of a sudden in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-Date-Calculation-is-showing-blank-all-of-a-sudden/m-p/1819690#M38581 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>Can anyone help me trouble shoot why my dax formula would suddenly calculate (blank)? It has never done this to me before.&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>WorkingDay = VAR UsedDate = Today() -2</SPAN></DIV><DIV><SPAN>VAR FirstDayOfMonth =</SPAN></DIV><DIV><SPAN>DATE( YEAR( UsedDate ), MONTH( UsedDate ), 1 )</SPAN></DIV><DIV><SPAN>VAR WorkDays =</SPAN></DIV><DIV><SPAN>COUNTROWS(</SPAN></DIV><DIV><SPAN>FILTER(</SPAN></DIV><DIV><SPAN>ADDCOLUMNS(</SPAN></DIV><DIV><SPAN>CALENDAR(</SPAN></DIV><DIV><SPAN>FirstDayOfMonth,</SPAN></DIV><DIV><SPAN>UsedDate</SPAN></DIV><DIV><SPAN>),</SPAN></DIV><DIV><SPAN>"WeekDayNumber", WEEKDAY(</SPAN></DIV><DIV><SPAN>[Date],</SPAN></DIV><DIV><SPAN>2</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>),</SPAN></DIV><DIV><SPAN>[WeekDayNumber] &lt; 6</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>WorkDays</SPAN></DIV></DIV> Mon, 03 May 2021 11:26:11 GMT canddig 2021-05-03T11:26:11Z My Date Calculation is showing blank all of a sudden https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-Date-Calculation-is-showing-blank-all-of-a-sudden/m-p/1819690#M38581 <P>Hello,&nbsp;</P><P>&nbsp;</P><P>Can anyone help me trouble shoot why my dax formula would suddenly calculate (blank)? It has never done this to me before.&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>WorkingDay = VAR UsedDate = Today() -2</SPAN></DIV><DIV><SPAN>VAR FirstDayOfMonth =</SPAN></DIV><DIV><SPAN>DATE( YEAR( UsedDate ), MONTH( UsedDate ), 1 )</SPAN></DIV><DIV><SPAN>VAR WorkDays =</SPAN></DIV><DIV><SPAN>COUNTROWS(</SPAN></DIV><DIV><SPAN>FILTER(</SPAN></DIV><DIV><SPAN>ADDCOLUMNS(</SPAN></DIV><DIV><SPAN>CALENDAR(</SPAN></DIV><DIV><SPAN>FirstDayOfMonth,</SPAN></DIV><DIV><SPAN>UsedDate</SPAN></DIV><DIV><SPAN>),</SPAN></DIV><DIV><SPAN>"WeekDayNumber", WEEKDAY(</SPAN></DIV><DIV><SPAN>[Date],</SPAN></DIV><DIV><SPAN>2</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>),</SPAN></DIV><DIV><SPAN>[WeekDayNumber] &lt; 6</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><BR /><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>WorkDays</SPAN></DIV></DIV> Mon, 03 May 2021 11:26:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-Date-Calculation-is-showing-blank-all-of-a-sudden/m-p/1819690#M38581 canddig 2021-05-03T11:26:11Z Re: My Date Calculation is showing blank all of a sudden https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-Date-Calculation-is-showing-blank-all-of-a-sudden/m-p/1819728#M38582 <P>Very simple if you run this code in DAX Studio:</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">EVALUATE VAR UsedDate = TODAY() - 2 // today must be 2021-05-03 VAR FirstDayOfMonth = DATE( YEAR( UsedDate ), MONTH( UsedDate ), 1 ) VAR WorkDays = ADDCOLUMNS( CALENDAR( FirstDayOfMonth, UsedDate ), "WeekDayNumber", WEEKDAY( [Date], 2 ) ) -- [WeekDayNumber] &lt; 6 RETURN WorkDays</LI-CODE><P>&nbsp;</P> Mon, 03 May 2021 11:48:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-Date-Calculation-is-showing-blank-all-of-a-sudden/m-p/1819728#M38582 daxer-almighty 2021-05-03T11:48:17Z Re: My Date Calculation is showing blank all of a sudden https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-Date-Calculation-is-showing-blank-all-of-a-sudden/m-p/1820285#M38612 <P>Thanks! I am still getting an error and I am not sure why? I am seeing it as infinity in calculations or (blank)</P> Mon, 03 May 2021 16:48:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-Date-Calculation-is-showing-blank-all-of-a-sudden/m-p/1820285#M38612 canddig 2021-05-03T16:48:25Z