Forum Discussion
Xandman
Helper II
Helper IIFinding ID and checking if completed or not
Hi I have 2 tables, one is a record of all the received work and another table is all the completed work. Both are linked to a ID list. I can't combine them since some columns do not exist on bot...
Xandman
You can create three columns in the Received Tables as follows:Completed Person = LOOKUPVALUE( Completed[Person] , Completed[Completed ID] , 'Received'[Received ID])Non Completed Person = IF( ISBLANK(LOOKUPVALUE( Completed[Person] , Completed[Completed ID] , 'Received'[Received ID])), 'Received'[Person] )Days to Complete = var __date = LOOKUPVALUE( Completed[Date] , Completed[Completed ID] , 'Received'[Received ID]) return IF( __date <> BLANK() , DATEDIFF( 'Received'[Date] , __date , DAY )+1 )
Fowmy
Super User
Super UserXandman
You can create three columns in the Received Tables as follows:
Completed Person = LOOKUPVALUE( Completed[Person] , Completed[Completed ID] , 'Received'[Received ID])
Non Completed Person =
IF( ISBLANK(LOOKUPVALUE( Completed[Person] , Completed[Completed ID] , 'Received'[Received ID])), 'Received'[Person] )
Days to Complete =
var __date =
LOOKUPVALUE( Completed[Date] , Completed[Completed ID] , 'Received'[Received ID])
return
IF( __date <> BLANK() , DATEDIFF( 'Received'[Date] , __date , DAY )+1
)
XandmanHelper II
Helper IIThank you again! I didnt realize it could be done this way.