cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Srikanth7Gunnam
Frequent Visitor

Puling Azure DevOps data using OData and dynamically changing calendar

Hello, 

We are pulling Azure DevOps Data using OData queries. The issue we are facing is we have different PI and Sprint start and end dates for different projects in Azure DevOps. We want to know the status of each work item status at the start and end of PI/Start. Can someone help us with this?

 

For instance, we have Project A and B in our Azure DevOps organization

Project A Sprint Calendar

Sprint 1 1/4/2021 to 1/17/2021

Sprint 2 1/18/2021 to 1/31/2021

Project B Sprint Calendar

Sprint 1 1/5/2021 to 1/17/2021

Sprint 2 1/19/2021 to 1/31/2021

 

Data from workitem history

Workitemid     Project    CreatedDate  ClosedDate  State               Status at Start                        Status at End

123                    A              1/4/2021                         New       Created on sprint start

123                    A              1/4/2021     1/17/2021  Closed     Created on sprint start         Closed before sprint end

234                    B              1/5/2021                         New       Created on sprint start

234                    B              1/5/2021     1/27/2021  Closed     Created on sprint start         Closed before sprint end

 

How to dynamically check the sprint calendar based on the project?

1 REPLY 1
V-pazhen-msft
Community Support
Community Support

@Srikanth7Gunnam 

Your requirement is not very clear to me what columns do you expect or something else? Maybe provide a short sample pbix to show the current model and explain the expected output.

 

Regards
Paul

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors