Forum Discussion
aflintdepm
Helper III
Helper IIICalculation based on multiple columns in related table
I am trying to create a resource table for a project that monitors the progress of tasks and assigns a value to the progress of the task, based on 2 criteria. I can't figure out how to get the fact ...
option 1 :
calculated column ==
lookupvalue (
table_2 [ points] ,
table_2[Task_name], table_1[Task_name],
table_2[Status], table_1[Status]
)
option 2 :
cc =
maxx (filter (table_2 , table_2[Task_name] = table_1[Task_name] && table_2[Status] = table_1[Status])
let me know if it works for you .
If my answer helped sort things out for you, feel free to give it a thumbs up and mark it as the solution! It makes a difference and might help someone else too. Thanks for spreading the good vibes! 👍🤠
Ashish_Mathur
Super User
Super UserHi,
Write this calculated column formula in the first table
Points = calculate(sum(RT[Points]),filter(RT,RT[Task_Name]=earlier(FT[Task_Name])&&RT[Status]=earlier(FT[Status])))
Hope this helps.