Forum Discussion

Kiggsworthy's avatar
Kiggsworthy
Regular Visitor
7 years ago
Solved

help showing when priority changed on work items in azure devops

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 ...
Need Help
Tutorial Requests
  • parry2k's avatar
    parry2k
    7 years ago

    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's avatar
Kiggsworthy
Regular Visitor
7 years ago

 

haha, sorry about that

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

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