Forum Discussion

FEninja_'s avatar
FEninja_
Helper I
3 years ago
Solved

Azure DevOps - Chart Recreation

UPDATE: PBI FILE => https://www.dropbox.com/s/250cnke1ulpy4sy/sample-problem.pbix?dl=0 === Hello All, Relative Newbie here. I am attempting to recrease an Azure DevOps Chart in PBI - but I am enc...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi FEninja_ ,

     

    The logic of Measure2 is as follows:
    First get the start and end dates selected by your slicer via the MIN and MAX functions, then 

    [Created Date]<=MIN('Calendar'[Date])&&[Completed Date]>=MAX('Calendar'[Date])&&[Work Item Type]=" User Story"

    filters the data within the time period selected by the slicer and finally obtains the result by calculation.

    Since I'm not quite sure what your sprint start and sprint end refer to, you may need to make some adjustments based on the actual situation.
    I hope this can help you.

     

    Best Regards,

    Jianbo Li

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

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi FEninja_ ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Jianbo Li

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