Trend Analysis for Open and Closed Issues from Two Different Dates

[AkshayManke]

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.

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

[AkshayManke · Accepted solution]

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...

[v-shex-msft]

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