Forum Discussion
ABC11
Resolver I
2 years agowant to see within GOALIMIT ROW
Hello to All, Only want to see one row per LEMNUM - within GOALIMIT when LEMNUM is same- color in BLUE As example LEMNUM 322185 - LINE_COST 279,000>250,000 and 279,000<=500,000 so PERSONID- MATTHE...
- 2 years ago
Thanks lots for your time
- 2 years ago
ABC11
Here are the modified codes:
Calculated Column:APPROVER = VAR __LemnumFiltered = FILTER( Table03 , Table03[LEMNUM] = EARLIER(Table03[LEMNUM]) && Table03[ GOALIMIT ] > Table03[ LINE_COST ] ) VAR __ApproverAmount = MINX( __LemnumFiltered , Table03[ GOALIMIT ] ) VAR __Result = CONCATENATEX( FILTER( __LemnumFiltered , Table03[ GOALIMIT ] = __ApproverAmount ) , Table03[PERSONID],"|" ) RETURN __Result
New Table:New Table = FILTER( Table03 , CONTAINSSTRING( Table03[APPROVER], Table03[PERSONID] ) )
Fowmy
Super User
2 years agoABC11
Here are the modified codes:
Calculated Column:
APPROVER =
VAR __LemnumFiltered = FILTER( Table03 , Table03[LEMNUM] = EARLIER(Table03[LEMNUM]) && Table03[ GOALIMIT ] > Table03[ LINE_COST ] )
VAR __ApproverAmount = MINX( __LemnumFiltered , Table03[ GOALIMIT ] )
VAR __Result = CONCATENATEX( FILTER( __LemnumFiltered , Table03[ GOALIMIT ] = __ApproverAmount ) , Table03[PERSONID],"|" )
RETURN
__Result
New Table:
New Table = FILTER( Table03 , CONTAINSSTRING( Table03[APPROVER], Table03[PERSONID] ) )
ABC11
Resolver I
2 years agoThanks lots