Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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
Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

Can you share the source date of this Matrix? 
You can paste the data from Excel with your rely or save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

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

YouTube, LinkedIn

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 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
      Super User
      5 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
        5 years ago
        _MonthEnd returns 31 dec 2020, so not able to get count between months.  Note : I have ticket January to sep for now