Forum Discussion

ctedesco3307's avatar
ctedesco3307
Icon for Resolver II rankResolver II
4 years ago
Solved

Date diff Working Days to Today with filter

I have a table that has all the working days identifed for a project between the start and end date. I need a measure to add up all the working days for each project from Start date to today, Thanks in advance 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi ctedesco3307 ,

     

    I suggest you to try this code to create a measure.

    Measure = 
VAR _MINDATE = MIN(MAX('Table'[End Date]),TODAY())
VAR _COUNT = CALCULATE(SUM('Table'[Working Day]),FILTER('Table','Table'[MSSContractDay]<=_MINDATE))+0
RETURN
_COUNT

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

6 Replies