Forum Discussion

DevadathanK's avatar
DevadathanK
Icon for Resolver I rankResolver 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

     

2 Replies

  • michaelx2's avatar
    michaelx2
    Icon for Microsoft Employee rankMicrosoft 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