Get Active days count

[ramanathans]

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]

Thanks a lot. That helped.

[amitchandak · Accepted solution]

@ramanathans , I have worked on a similar problem in past,see if the attached file after signature can help