Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
itsmk86
Helper I
Helper I

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

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. 

1 ACCEPTED SOLUTION
v-lionel-msft
Community Support
Community Support

Hi @itsmk86 ,

 

Please refer to my .pbix file.

v-lionel-msft_0-1613544447698.png

 

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.

 

View solution in original post

2 REPLIES 2
v-lionel-msft
Community Support
Community Support

Hi @itsmk86 ,

 

Please refer to my .pbix file.

v-lionel-msft_0-1613544447698.png

 

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
Super User
Super User

@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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.