Forum Discussion
help showing when priority changed on work items in azure devops
Kiggsworthy Add new column like this
Is Today Priority 1 = IF( ( Table[CreateDate] ) = TODAY() || Table[Date] = TODAY() ) && Table[Priority] = 1, 1, 0 )
Add new measure to get count of todays priority
Today's Priority Count = SUM( Table[Is Today Priority 1] )
Resolver IIThe real question you need to as is if your data shows the date of priority changes. If it isn't in the data then you can't show it.
This is a great community such fast responses thank you!
So it is in the data:
Here is an example of a work item that I want on the report I am trying to build.
It has existed for 10 days, but only today it was updated to priority 1. So on my "Todays' P1s" report, I want this item to show. I would like a simple table report that is just a list of the work item with ID, title, who it is assigned to, etc. And I just want that list to contain
* Items that are P1 that were created today (easy)
* Items that are P1 that *changed to* P1 today (like in the above screenshot)
Thank you for your responses and hopefully someone can help me do this :)
- ntaylo06
Thanks for the screenshot, but can you post it again without covering up the field names? It is hard to help when we can't see them.
haha, sorry about that
and here is where I was able to figure out the first part (items that were created today w/ p1):
so I just need to find a way to add the items that *changed* today to P1.