Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Matrix calculation

Hi All, I dervied matrix table like below. This data contains each month requested, resolved incidents count.  from below i need total unresolved incident count on each month .  Example  During Apri...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I may not able load excel(due to security) ,  my source will be like this

so, i used matrix to get total count for individual requested date and resloved date. if resolved date = null. (Then is unresolved one). Hope this helps

 

NumRequested DateResolved Date
52868715 June 202026/06/2020 14:03
51772211 May 202011/05/2020 10:20
51705415 April 202015/04/2020 18:13
49589802 March 202004/03/2020 11:27
45354202 December 201904/12/2019 14:53
45274104 November 201904/11/2019 15:26
42622625 March 201926/03/2019 17:24
40460329 January 201929/01/2019 14:48
40451225 January 201928/01/2019 11:51
36247909 November 201805/12/2018 10:44
29417426 March 201826/03/2018 14:53
27144308 January 201810/01/2018 11:31
27136104 January 201810/01/2018 11:30
27136104 January 2018null
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
6 years ago

Anonymous 

Create a Calendar Table and link it to your data table


Create the following Measure to calculate the Unresolved Tickets

Unresolved incidents = 
VAR _MonthEnd = MAX(Dates[Date]) RETURN
COUNTROWS(
    FILTER(
        ALLSELECTED(Incidents),
        Incidents[Requested Date] <= _MonthEnd && Incidents[Resolved Date] >= _MonthEnd
    )
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    _MonthEnd returns 31 dec 2020, so not able to get count between months.  Note : I have ticket January to sep for now