Display Open Backlog over time

[Lucky_13]

Hello, 

I am new in Power BI, coming from a pure Excel background, I was wondering if someone could help me to display graphically the evolution of open cases over time, in order to show for each day/week/month.... the number of cases that are in an open status? 

Here is the table showing the type of data I have: 

and this is the graphical result I am looking for:

[Lucky_13]

@amitchandak , Thanks a lot for the swift response and great example. I replicated your modell without getting error messages, but I was unable to get a dynamic view on the created measures:

Then i downloaded your file (Current_employee.pbix) to compare and try to identify what I did wrong, but got the result in your exemple:

Am I missing something?

Thanks in advance for your support.

[amitchandak]

@Lucky_13 ,
Can you share a sample pbix after removing sensitive data.

Also, I have attached the file with the last update, use those. They are updated the version of the files. Check last update and files are after signature

[Lucky_13]

@amitchandak Unfortunatly, I can't share the file with you on short notice, as I would need to take out a lot of sensitive data.....

I can't find your updated file. Would you mind posting it again?

[amitchandak · Accepted solution]

@Lucky_13 , refer if my Hr Blog on same topics van help.

You need current employee

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Or the attached files can help