Help with progress of issues visualization

[jereaallikko]

Hi all,

I need help in drawing a line or column chart that shows the amount of items with status=open over time. So for instance, 3 days ago there were 2 open items, two days ago 3, yesterday 1 and today 2. (The excel below is not corresponding to this example, but hopefully you get the idea).

The data is coming from the protected source, but I have illustrated the columns such as:

ID	Status	Created at	Closed at	Reporter	Department
57938	Open	3.1.2021	null	Jack	Sales
57930	Closed	14.4.2021	15.4.2021	Megan	Sales
78983	Pending	4.4.2021	null	Rachel	Marketing
57899	Open	16.4.2021	null	John	Finance
29057	Closed	6.12.2020	14.4.2021	Ricky	Sales
28947	Closed	16.11.2020	13.3.2021	Tom	Finance

So the basic idea is to draw a chart, that I can visualize number of open items compared to yesterday and days before yesterday versus today.

Do I have to create a separate date table to be able to track historical data? Can someone help me out with the issue?

If something is unclear and more information needed, don't hesitate to ask.

BR

Jere Aallikko

[jereaallikko]

Hi @Jihwan_Kim 

That worked out perfectly. Needed to modify the DAX calculations a bit to my specific data but managed to do it. 

Thanks a lot!

Br

Jere

[Jihwan_Kim · Accepted solution]

Hi, @jereaallikko 

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

All measures are in the sample pbix file.

https://www.dropbox.com/s/tgw3rb1a31vk8v2/jera.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/