Forum Discussion
Solved
Return value based on condition
ID Title Work Item Type Hierarchy Path Parent ID Closed Date 7141 Test -- Epic 7141 7142 F1 Feature 7141|7142 7141 7143 US-1 User Story 7141|7142|7143 71...
vijaykumarj19 , Try like this
new column = var _1 = countx(filter(table,[parent ID ] =earlier([parent ID ]) && [code] <earlier([code])),[ID] ) var _2 = countx(filter(table,[parent ID] =earlier([parent ID]) && [code] <earlier([code]) && [Closed Date ] <earlier([Closed Date ]) ),[ID] ) return if(_1 =_2 , "OK",blank())Or with additional columns
//additional column code = left([Title],len([Title])-1) // we can use parent ID sequence= right([Title]) new column = var _1 = countx(filter(table,[code] =earlier([code]) && [sequence] <earlier([sequence])),[ID] ) var _2 = countx(filter(table,[code] =earlier([code]) && [sequence] <earlier([sequence]) && [Closed Date ] <earlier([Closed Date ]) ),[ID] ) return if(_1 =_2 , "OK",blank())
vijaykumarj19 , I am not able to logic, how do you get three are before 7151 not others?
In title there is a prefix C003,C002,C001 by using these need to compare C004(7151 prefix)
vijaykumarj19 , Try like this
new column = var _1 = countx(filter(table,[parent ID ] =earlier([parent ID ]) && [code] <earlier([code])),[ID] ) var _2 = countx(filter(table,[parent ID] =earlier([parent ID]) && [code] <earlier([code]) && [Closed Date ] <earlier([Closed Date ]) ),[ID] ) return if(_1 =_2 , "OK",blank())Or with additional columns
//additional column code = left([Title],len([Title])-1) // we can use parent ID sequence= right([Title]) new column = var _1 = countx(filter(table,[code] =earlier([code]) && [sequence] <earlier([sequence])),[ID] ) var _2 = countx(filter(table,[code] =earlier([code]) && [sequence] <earlier([sequence]) && [Closed Date ] <earlier([Closed Date ]) ),[ID] ) return if(_1 =_2 , "OK",blank())
