Start Date and End Date counting for months in between

[alpeytongreene]

I am working on a contract labor dashboard, I need to count the person in contract from their start date through their end date- without having to create multiple entries per each labor.

Example:

Bob Smith started 01-01-2021 and ends July 30, 2021- so Bob would count January, February, March, April, May, June, and July 

Sally Sue started February 15 and ends May 15- so Sally would count February, March, April, and May. 

It would be filtered multiple ways from the same data. 

Is there a way to do this where I would not have to manually update/enter the data for each month? 

[gvrajesh]

@alpeytongreene 

Create datetable and measure like below

[alpeytongreene]

Will it work if I already have that data in my model just not as a direct table. 

[gvrajesh]

If you've date table...that will work

[Anonymous]

@gvrajesh What should we join the Date table to on with fact table? Start Date? Or no need to join?

[alpeytongreene]

@gvrajesh 

I have the formula set as: 

Count =

VAR Tab =

FILTER('CL Labor Count Table',

'CL Labor Count Table'[Start Date]<= MAX('Date Table'[Date])

&& 'CL Labor Count Table'[End Date]>= MIN('Date Table'[Date])

)

RETURN

CALCULATE(COUNT('CL Labor Count Table'[Lawson ID]), Tab)

but this is  only showing to the start month.