Forum Discussion

ValerienSegard's avatar
ValerienSegard
Frequent Visitor
5 years ago
Solved

Completed Work by cascade (Issue -> Epic -> Objective)

Hello everybody   I would like to use our Azure Devops to monitor the progress of our projects.   The architecture is as follows: Objective> Epic> Issue   Objective can have many epics, but on...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    5 years ago

    Hi ValerienSegard  - 

     

    First thing to do is see if you can change your data model (inside PBI) to have Objective, Epic and Issue in 3 separate tables with 1-to-many relationships (1 Objective to Many Epic, 1 Epic to Many Issue). If you can do that, it will make things much easier.

     

     

    Once you do that, create a column on Issue for the IssueDuration

     

    IssueDuration = DATEDIFF(Issues[Start Date], Issues[End Date], DAY)

     

    Then a measure for the rolled up Completion %

     

    Completion Pct =
DIVIDE (
    SUMX ( Issues, Issues[IssueDuration] * ( Issues[Completion] / 100 ) ),
    SUM ( Issues[IssueDuration] ),
    0
)

     

    Hope this helps

    David

     

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
5 years ago

Hi ValerienSegard  - 

 

First thing to do is see if you can change your data model (inside PBI) to have Objective, Epic and Issue in 3 separate tables with 1-to-many relationships (1 Objective to Many Epic, 1 Epic to Many Issue). If you can do that, it will make things much easier.

 

 

Once you do that, create a column on Issue for the IssueDuration

 

IssueDuration = DATEDIFF(Issues[Start Date], Issues[End Date], DAY)

 

Then a measure for the rolled up Completion %

 

Completion Pct =
DIVIDE (
    SUMX ( Issues, Issues[IssueDuration] * ( Issues[Completion] / 100 ) ),
    SUM ( Issues[IssueDuration] ),
    0
)

 

Hope this helps

David