Forum Discussion
Calculation based on multiple columns in related table
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! 👍🤠
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! 👍🤠
Just to make sure I understand and test correctly:
In my fact table, I would add a column with the formula, and "Table_2" refers to the resource table?
sorry didnt notice the table names
the is correct.
fact table == table_1
Resource table with point values == table_2
you creat the column in table _ 1