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.