Forum Discussion

DevadathanK's avatar
DevadathanK
Resolver I
6 years ago
Solved

Connecting Rows to Columns of Two tables

Hi everyone, <Message deleted> Thanks for any help!  
Need Help
  • michaelx2's avatar
    michaelx2
    6 years ago

    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

     

michaelx2's avatar
michaelx2
Microsoft Employee
6 years ago

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