Net Working Days through Today

[hisackman]

Having trouble with getting networing days through today to work appropriately in the tables. There is a filter on the page, but all months are showing the total networking days. Can someone help with this issue?

YTD Net Working Days =

Var _FirstDate = Min ( 'Calendar'[Date])

Var _LastDate = today()-1

Var _Holiday = calculatetable( distinct('Calendar'[Date]),'Calendar'[IsHoliday] = "TRUE")

Return

if(LOOKUPVALUE('Calendar'[Sales Season],'Calendar'[Date],_FirstDate)="AEP",

networkdays(_FirstDate,_LastDate,11,_Holiday),

networkdays(_FirstDate,_LastDate,1,_Holiday))

[FreemanZ]

hi @hisackman ,

try like:YTD Net Working Days =

Var _FirstDate = Min ( 'Calendar'[Date])

Var _LastDate = Max ( 'Calendar'[Date])

Var _Holiday = calculatetable( distinct('Calendar'[Date]),'Calendar'[IsHoliday] = "TRUE")

Return

if(LOOKUPVALUE('Calendar'[Sales Season],'Calendar'[Date],_FirstDate)="AEP",

networkdays(_FirstDate,_LastDate,11,_Holiday),

networkdays(_FirstDate,_LastDate,1,_Holiday))

[hisackman]

That gives me the working days through the selected date. What I'm trying to see is my run rate. I.e. if I select a preiod longer than today, it will show the average sales per day over the ytd working days, multiplied by the net working days as my run rate. Essentially ... (YTD sales / YTD days) * period net working days