Forum Discussion

Moller70's avatar
Moller70
Frequent Visitor
3 years ago

Calculate total working dates

Hi. I have a tabel "Start Stop" where i have start and end dates for each employee. Same employee can start and stop more times.   I have a date tabel and a employee tabel with relations.   I wa...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Working_Days= var max = Maxx(Allselected(Date), Date[Date])

                          var min = Minx(allselected(Date), Date[Date]) 

return

                          Networkdays(max(min ,[Start Date]), Max(max, [End Date]),1)