Forum Discussion
WORKDAY Function a little different
Hello all, I have been trying to figure this one out using all the great suggestions on the subject. I feel I am very close, but cannot find it yet. I am creating a production planner that ba...
Answering my own question.
I created an index on the date table that would only go up when the day was a workday.
Row Index Column =CALCULATE( COUNTROWS('Date'), FILTER(All('Date'), 'Date'[Date] <= EARLIER('Date'[Date])), 'Date'[WorkingDay] = 1)Then I found the first day that had a rank equal to my leadtime
PlanDate= MINX(FILTER('Date','Date'[Row Index Column] = PlannerInfo[LeadTime]), 'Date'[Date])
Answering my own question.
I created an index on the date table that would only go up when the day was a workday.
Row Index Column =
CALCULATE( COUNTROWS('Date'), FILTER(All('Date'), 'Date'[Date] <= EARLIER('Date'[Date])), 'Date'[WorkingDay] = 1)
Then I found the first day that had a rank equal to my leadtime
PlanDate= MINX(FILTER('Date','Date'[Row Index Column] = PlannerInfo[LeadTime]), 'Date'[Date])