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 amitchandak ,

thank you for the help but it still doesnt work with that measures.

 

In this example, it started in January and finished in March. I should see a 1 in January an February until March. If I create also a measure to show the "resolved" ones, there would bei Created 1 in Jan 1 in Feb and resolved 1 in March.

 

Do you have any ideas for this use case?