Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Start Date and End Date counting for months in between

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? 

contract
dax formula
Months between

5 Replies

  • gvrajesh's avatar
    gvrajesh
    Frequent Visitor
    5 years ago

    Anonymous 

    Create datetable and measure like below

     

     

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

      • gvrajesh's avatar
        gvrajesh
        Frequent Visitor
        5 years ago

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