Need Help in creating a simple Report

[vikrantyadav11]

Hi Guys, 

I am new to Power BI, I need to help in creating a report using below data in Power BI. Can you please guide me how can I create such report.

Report Should be like this : 
Show the count of Total Issue Assignee , then Issue Resolved Per Quarter, last column for Open issue left : Sum(Q1,Q2,Q3,Q4) - Total Issue Assigned. 

Assignee	Total Issue Assigned	Resolved Per Quarter  Q4-2023	Q1-2024	Open
Merry	2		1	1
John	6	1	2	3
Riswan I	8		1	7
Vikrant Yadav	4		2	2
Sabarimani Ramamoorthi	2			2

Issue key	Summary	Created	Updated	Assignee	Resolution	Resolved
ABC-5619	Creating new PowerBI dashboard for Zoom App	5/29/2024 12:39	5/29/2024 12:39	Merry
ABC-5610	To Create New Records in Snipe IT Based on the Invoice	5/28/2024 15:15	5/28/2024 15:15	John	Done	5/28/2024 15:15
ABC-5609	Status Transition for Security Issue Type to be added	5/28/2024 13:20	5/28/2024 15:11	Riswan I
ABC-5608	Automate Jira and Confluence Cleanup Activity	5/28/2024 12:21	5/28/2024 12:27	Vikrant Yadav
ABC-5607	Serial number missing on the invoice	5/27/2024 18:12	5/27/2024 18:13	Riswan I
ABC-5606	Cleanup of the To recycle status with active user	5/27/2024 16:47	5/27/2024 16:48	Riswan I
ABC-5605	User active legacy status cleanup	5/27/2024 16:46	5/27/2024 16:46	Riswan I
ABC-5604	Documentation and implementation of the New Asset Onboarding in Snipe IT	5/27/2024 15:09	5/27/2024 15:14	John
ABC-5603	Documentation and implementation of the Laptop Gifting	5/27/2024 14:58	5/27/2024 15:44	Riswan I
ABC-5602	Documentation and implementation of the Asset replacement process	5/27/2024 14:55	5/27/2024 15:44	Riswan I
ABC-5601	Ticket #1173476 Create app registration for VOIP monitor	5/27/2024 14:29	5/27/2024 14:30	Sabarimani Ramamoorthi
ABC-5600	Adding Zoom Reports on the Collabs tools	5/27/2024 12:09	5/27/2024 12:09	Riswan I
ABC-5575	Zero Junk Email Initiative - CTO DL List	5/24/2024 17:02	5/24/2024 17:04	Sabarimani Ramamoorthi
ABC-5572	fixVersion 19.8	5/23/2024 15:49	5/27/2024 10:14	Vikrant Yadav	Fixed	5/23/2024 16:35
ABC-5571	Asset Wipe Confirmation	5/23/2024 13:17	5/23/2024 13:18	John	Done	5/23/2024 13:18
ABC-5570	To Create New Records in Snipe IT Based on the Invoice	5/23/2024 12:54	5/23/2024 13:13	John	Done	5/23/2024 13:13
ABC-5566	Zephyr Test Cases Fields	5/22/2024 21:10	5/27/2024 12:25	Vikrant Yadav
ABC-5564	Slack KT	5/22/2024 20:20	5/22/2024 20:49	John
ABC-5563	Reports For ITAM	5/22/2024 20:19	5/24/2024 21:42	John
ABC-5557	Creating new Lucid chart powerbi Dashboard	5/22/2024 12:18	5/28/2024 12:42	Merry	Done	5/28/2024 12:42
ABC-5556	New Custom Field: UI Story Points	5/22/2024 10:16	5/27/2024 10:15	Vikrant Yadav	Fixed	5/23/2024 13:38
ABC-5548	Create the new snipe IT status To Loan (Location)	5/21/2024 20:23	5/22/2024 21:03	Riswan I	Fixed	5/22/2024 21:03

[Anonymous · Accepted solution]

Hi, @vikrantyadav11 

In fact, @rajendraongole1  was gave the correct Measure and you can use these Measure in the steps below.

Or you can try the following measure

Resolved Q2 2024 = 
CALCULATE (
    COUNTROWS ( Issue ),
    FILTER (
        'Issue',
        'Issue'[Resolved] >= DATE ( 2024, 4, 1 )
            && 'Issue'[Resolved] <= DATE ( 2024, 7, 31 )
    )
)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[vikrantyadav11]

Hi @rajendraongole1  Thanks for your response!

I have Power BI online. I am not sure where to write to these measures. So sorry asking such basic question. 

Can we connect over linkedin? 

[rajendraongole1]

Hi @vikrantyadav11 - You can achieve this by using table/matrix visualization with some measures that need to create as below:

Measure 1:

Total Issue Assigned = COUNTROWS('Issue Data')

Measure 2: 

Resolved Q1 = CALCULATE(COUNTROWS('Issue Data'), 'Issue Data'[Resolved] >= DATE(2024, 1, 1) && 'Issue Data'[Resolved] < DATE(2024, 4, 1))

similarly, you can create measures for Q2, Q3, and Q4.

Measure 3:

Open Issue Left

Open Q1 = [Total Issue Assigned] - [Resolved Q1]

you can create a Power BI report that shows the count of total issues assigned, issues resolved per quarter, and open issues left per quarter for each assignee

FYR: Microsoft Power BI Learning resources :

Power BI Learning Resources – Data Analytic Group

Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI (youtube.com...

Please go through the above link to find more about learning resources

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!