Count values between two date stamps on week level

[Anonymous]

Hi community,

I have data which conclues issues for machines in a fleet. The data inclues a date stamp when the issue is reported and when it is fixed (if the issue is unresolved, the "fixed date" cell is blank). So all issues are either open or fixed.

I would like to make a graph, which shows the open issues on a week level. So, I would need to count the issues, but for each week separately, and then filter that on for each week in my graph. 

Thanks!

[amitchandak · Accepted solution]

@Anonymous , I have a blog on a similar kind of data

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

Also for week you need to improve your date table

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

Or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.