Forum Discussion
Using Networkdays in further calculations
- 4 years ago
lbendlin , I do have the option to edit the date dimension table. I was able to get this to finally work by joining the date fields from both date dimension tables. I believe that is part of what is messing up my data having two tables like this. I did not have a SQL end database at first when I was creating this report. I'm going to have to rebuid this fully using the SQL date dim table next which should prevent any date issues I was seeing.
Since my oringial data only has an event date, my ending formula ended up looking like this using datesbetween: WorkingDayPoints = CALCULATE(COUNTA(DimDatenew[WorkDay]),DATESBETWEEN('Data'[Initial Decision Date],STARTOFMONTH('Data'[Initial Decision Date]),ENDOFMONTH('Data'[Initial Decision Date])))
I ended up creating another date dimension table in SQL and brought that in. This table has a field for holiday, weekend and if it's a working day (not holiday or weekend).
you can do that - or you could augment your existing calendar table by indicating which days are working days. Would that be an option?