cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AkshayManke Frequent Visitor
Frequent Visitor

Trend Analysis for Open and Closed Issues from Two Different Dates

Hi,

 

We have created a Power BI Reports Dashboard which gets data from a SharePoint List. The list is for Issue Tracking(Similer like IT Helpdesk System).

 

I want to create a visualization where i can see a trend of open & closed issues like shown in the below snap.Snap.JPG

 

 

There is a default column called Created which is capturing the date when the issue is created, and i have created an column called Closure Date just to track when the issue is closed (when the support person resolves the issue, the date and time stamp gets added in to the column).

 

The problem I am facing here is, I want to calculate the number of issues using two different date columns and not able to find any solution for that. 

 

Can someone please advise for a solution ro with correct direction.

 

Regards,

Akshay

 

1 ACCEPTED SOLUTION

Accepted Solutions
AkshayManke Frequent Visitor
Frequent Visitor

Re: Trend Analysis for Open and Closed Issues from Two Different Dates

I have got a solution on the reply of Phil_Seamark and it worked as expected. Below is the link for reference.

https://community.powerbi.com/t5/Desktop/Plotting-2-dates-from-same-data-table-on-a-line-and-stacked...

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Trend Analysis for Open and Closed Issues from Two Different Dates

HI @AkshayManke,

 

Current power bi not support direct analytics date range who define by two different date columns.

 

In my opinion, you can create new table with expand detail records and build relationship to original tables. Then you can simply create visuals to analytic records between these date ranges.

 

Reference link:

Spread revenue across period based on start and end date, slice and dase this using different dates

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
AkshayManke Frequent Visitor
Frequent Visitor

Re: Trend Analysis for Open and Closed Issues from Two Different Dates

I have got a solution on the reply of Phil_Seamark and it worked as expected. Below is the link for reference.

https://community.powerbi.com/t5/Desktop/Plotting-2-dates-from-same-data-table-on-a-line-and-stacked...

 

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 41 members 1,035 guests
Please welcome our newest community members: