Forum Discussion

kbart's avatar
kbart
Regular Visitor
4 years ago
Solved

Using Networkdays in further calculations

I'm working on rebuilding an Excel dashboard in Power BI and have gotten everything done except for measuring points.  My main data set is an export from an application that records various dates whe...
  • kbart's avatar
    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])))