Forum Discussion
Solved
Get Active days count
Hi Currently i have a table which has time periods in which an individual is active
| STAFF_CD | START_DT | END_DT |
| ABC | 09/19/2017 | 11/09/2019 |
| ABC | 02/01/2020 | 11/05/2020 |
DT is in MM/DD/YYYY format
I am trying to make a report which will give me this result, for every staff the number of working days they are active for a particular month on the basis of the above information
| STAFF_CD | OCT - 19 | NOV - 19 | DEC -19 | JAN -20 |
| ABC | 31 | 09 | 0 | 30 |
Is there any way in which i can create a measure to achieve the same?
ramanathans , I have worked on a similar problem in past,see if the attached file after signature can help
2 Replies
ramanathans , I have worked on a similar problem in past,see if the attached file after signature can help
Thanks a lot. That helped.
