Count of 'Log Item' completed per week for each epic in AzureDevOps board?

[itsmk86]

Can you please help me get the - Count of 'Log Item' completed per week for each epic ?

It's like in a hierarchy Epic is at the top , then feature then Log Item.

Epic has features , which in turn has bugs and log items.

(It's DevOps board).

Below is the table

ID Parent id Type Completed Date

10621 Blank Epic 1/15/2021 10:21
10622 10621 Feature 6/17/2019 14:09
10623 10621 Log Item 6/16/2019 14:09
100627 Blank Epic
29008  100627 Feature  2/1/2021  15:49
10924 29008 Log Item 2/1/2021 15:49
10994 29008 Bug 2/2/2021 13:49

PS - Please let me know how to upload excel directly to this site. 

Thanks in advance. 

[v-lionel-msft · Accepted solution]

Hi @itsmk86 ,

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@itsmk86 , Create a date from Completed Date (which has time)

Date = [Completed Date].date
or
Date = date(year([Completed Date]),month([Completed Date]),day([Completed Date]))

Join this with a Date table that has weeks and you can analyze week wise

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-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8