help showing when priority changed on work items in azure devops

[Kiggsworthy]

I have what I think is a very straightforward need, but it is proving remarkably difficult to achieve in practice. I don't think there's any way to do this in azure devops directly which is why I am using PowerBI.

I need a list of items that were added to my teams backlog today that are Priority 1.  One way this can happen is very easy, I can just use a query for work that has our team's area path, create date = @ today, and Priority =1.  But the other way I cannot figure out at all. That is when an item was already in our backlog, but the priority changed from something other than 1, to 1.  

ANy help on how to do this with powebi would be great. I have the analytics view with the correct data, I just have no idea how to ask power BI to show me items whose priority change to 1 by day.

[ntaylo06]

The 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.

[Kiggsworthy]

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. 

[Kiggsworthy]

haha, sorry about that

[parry2k · Accepted solution]

@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] )

[Kiggsworthy]

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.

[parry2k]

@Kiggsworthy do you have column for update date whcih you can use to get 2nd set of count where update date = @today and priority = 1