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])))
Hi kbart ,
Can you give me sample data or PBIX file without private data if it is convenient. This will make it easier for me to do tests and calculations. Thank you in advance~
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.