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