NETWORKDAYS overriding Variables

Question

Hello,&nbsp;I was struggling with the new function NETWORKDAYS, that does not give the proper value at total. I insvestigated, and end up, to the following DAX to put in evidence the issue ;&nbsp;Duration in work days from Release date to Last Ship Date = Var selection = ADDCOLUMNS(&nbsp; &nbsp; CALCULATETABLE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FACT_CUSTOMER_ORDER_LINE_C,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(FACT_CUSTOMER_ORDER_LINE_C ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FACT_CUSTOMER_ORDER_LINE_C[Date First Released] &lt;&gt; BLANK()&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; FACT_CUSTOMER_ORDER_LINE_C[Date Last Actual Ship] &lt;&gt; BLANK()&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; FACT_CUSTOMER_ORDER_LINE_C[Date First Released] &gt;= DATE(2022,01,05)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) ,&nbsp; &nbsp; "Date First Released bis" , FACT_CUSTOMER_ORDER_LINE_C[Date First Released] )VAR list_with_days =&nbsp; &nbsp; &nbsp; &nbsp; ADDCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;selection &nbsp; ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "calc_duration_work_day" ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR selected_site = SELECTEDVALUE(DIM_SITE[Site])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VAR list_exception = &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UNION(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATETABLE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTCOLUMNS('Calendar WORK_TIME_EXCEPTION_C', &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "exception date" ,'Calendar WORK_TIME_EXCEPTION_C'[EXCEPTION_DATE] &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ), TREATAS({selected_site},'Calendar WORK_TIME_EXCEPTION_C'[SITE] )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) , {[Date Last Actual Ship] &nbsp;}&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RETURN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NETWORKDAYS([Date First Released bis] , [Date Last Actual Ship] &nbsp; , 1 , &nbsp;list_exception &nbsp;)&nbsp; &nbsp; &nbsp; &nbsp; ) returnCONCATENATEX(list_with_days &nbsp;, &nbsp; &nbsp; FACT_CUSTOMER_ORDER_LINE_C[Date First Released] &nbsp; &amp; " to " &amp; &nbsp;FACT_CUSTOMER_ORDER_LINE_C[Date Last Actual Ship] &amp; " give " &nbsp;&amp; &nbsp; &nbsp; [calc_duration_work_day] , ", " , FACT_CUSTOMER_ORDER_LINE_C[Date First Released] ,ASC)&nbsp;Here below is the resulut I et.&nbsp;&nbsp;I thought the the duation of days would be stored in the variable&nbsp; "list_with_days" and frozen.&nbsp;But t seems the duration of days by line given afterwards has a different value.&nbsp;Does anyone already met this kind or issue ?&nbsp;Thanks in advance to the community for the support.Anthony&nbsp;&nbsp;

anthony_lecoq · Accepted Answer

To bypass&nbsp; this issue of inacuracy of NETWORKDAYS at the total line, I came back to the basic,&nbsp;I skipped the NETWORKDAYS funktion, and count days in a calculated variable table. and chetck that the aggregation worked properly at the end.&nbsp;Duration in work days from Release date to Last Ship Date2 = Var selection = &nbsp; &nbsp; CALCULATETABLE(&nbsp; &nbsp; &nbsp; &nbsp; FACT_CUSTOMER_ORDER_LINE_C,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(FACT_CUSTOMER_ORDER_LINE_C ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FACT_CUSTOMER_ORDER_LINE_C[Date First Released] &lt;&gt; BLANK()&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; FACT_CUSTOMER_ORDER_LINE_C[Date Last Actual Ship] &lt;&gt; BLANK()&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ) VAR list_with_days =&nbsp; &nbsp; &nbsp; &nbsp; ADDCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;selection &nbsp; ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "duration work days",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(ALL('Calendar'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WEEKDAY('Calendar'[Date],2) &lt;= 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; &nbsp;'Calendar'[Date] &gt;= &nbsp;[Date First Released]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; &nbsp;'Calendar'[Date] &lt; &nbsp;[Date Last Actual Ship] &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "count exception days",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(ALL('Calendar WORK_TIME_EXCEPTION_C'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FACT_CUSTOMER_ORDER_LINE_C[SITE] = 'Calendar WORK_TIME_EXCEPTION_C'[SITE]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [EXCEPTION_DATE] &gt;= &nbsp;[Date First Released]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; &nbsp;[EXCEPTION_DATE] &nbsp;&lt;= &nbsp;[Date Last Actual Ship] &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; ) &nbsp; &nbsp; &nbsp; &nbsp; returnCONCATENATEX(list_with_days &nbsp;, &nbsp; &nbsp; FACT_CUSTOMER_ORDER_LINE_C[Date First Released] &nbsp; &amp; " to " &amp; &nbsp;FACT_CUSTOMER_ORDER_LINE_C[Date Last Actual Ship] &amp; " give " &nbsp;&amp; &nbsp;[duration work days] - &nbsp;[count exception days] &nbsp; &nbsp;, ", " , FACT_CUSTOMER_ORDER_LINE_C[Date First Released] ,ASC)&nbsp;This new basic approch is much more accurate,&nbsp;&nbsp;I do not know how to reports these bug on NETWORKDAYS to developer team ?&nbsp;&nbsp;

Forum Discussion

NETWORKDAYS overriding Variables

1 Reply

Related content

Override filters

RLS Override

NETWORKDAYS() Holiday question

Help with NetworkDays column

Networkdays