Forum Discussion
Working days in different columns
Hello, guys
Need some help conting working days here.
I have a big database, something like 120K rows (for now) and aprox. 90 columns. Each one of these columns are dates.
Each row represents a client and each column represents a step in his process inside my company. A client don't need to pass through all steps, so some "cells" are blank.
The database looks like this:
Database
I need to count the working days between each 2 columns out of this base.
I've made onother base with working days all the way to 2020:
Columns name (in portugues) are: Date, weekday, tipe (working day or holliday)
I've read some articles teaching how to creat relationship between the working days table and the dates in my main table, but i have so many clumns and i don't know how to create relationship between all of them.
All i need is a pizza grafic that i can filter by process and see the % wich exceed 2 working days.
Sorry if bad english.
Read my article here. It should help you with the approach. https://powerpivotpro.com/2016/12/how-many-working-days-has-an-employee-been-off-work/
1 Reply
- MattAllington
Community Champion
Read my article here. It should help you with the approach. https://powerpivotpro.com/2016/12/how-many-working-days-has-an-employee-been-off-work/