Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Count over duration

Hello together,   I have the following problem. I have 2 columns with cases, "start date" and "resolved date". I would like to show a time course of the duration until the end over months. For exam...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Check the measures.

    create = CALCULATE(DISTINCTCOUNT('Table'[id]),FILTER(ALL('Table'),MONTH('Table'[start])<=MONTH(SELECTEDVALUE('calendar'[date]))&&MONTH('Table'[resolve])>MONTH(SELECTEDVALUE('calendar'[date]))))

resolve = CALCULATE(DISTINCTCOUNT('Table'[id]),FILTER(ALL('Table'),MONTH('Table'[resolve])<=MONTH(SELECTEDVALUE('calendar'[date]))))

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Check the measures.

create = CALCULATE(DISTINCTCOUNT('Table'[id]),FILTER(ALL('Table'),MONTH('Table'[start])<=MONTH(SELECTEDVALUE('calendar'[date]))&&MONTH('Table'[resolve])>MONTH(SELECTEDVALUE('calendar'[date]))))

resolve = CALCULATE(DISTINCTCOUNT('Table'[id]),FILTER(ALL('Table'),MONTH('Table'[resolve])<=MONTH(SELECTEDVALUE('calendar'[date]))))

 

Best Regards,

Jay