Forum Discussion
Solved
Connecting Rows to Columns of Two tables
Hi everyone,
<Message deleted>
Thanks for any help!
Hello DevadathanK ,
Please try to use following formula:
Week 1 Efficiency = table1[Week1]/ table1[Hours] * (5 - IF(COUNTROWS(FILTER(table2, table2[Week Number] = "Week1" && table1[Location] = table2[Location])) > 0,1,0))Best Regards
2 Replies
Hello DevadathanK ,
Please try to use following formula:
Week 1 Efficiency = table1[Week1]/ table1[Hours] * (5 - IF(COUNTROWS(FILTER(table2, table2[Week Number] = "Week1" && table1[Location] = table2[Location])) > 0,1,0))Best Regards- For this: table2.Week number
Use LOOKUPVALUE
