Forum Discussion

TWolsten's avatar
TWolsten
Icon for Advocate IV rankAdvocate IV
4 years ago
Solved

Pulling data from a range in a different table

Hi all,   Hopefully someone might have the answer to this query.   I have two tables which I need to compare Table 1 to Table 2 with the following criteria: Table1[from_code] = Table2[code] and...
General Comment
Need Help
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi TWolsten ,

     

    This part of the judgment condition seems to be somewhat incorrect. But the desired result can be obtained by creating the following formula.

    M = IF(120>=MAX(Table2[m]) && 5>=MAX(Table2[c]) ,1,0)

     

     


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi TWolsten ,

 

This part of the judgment condition seems to be somewhat incorrect. But the desired result can be obtained by creating the following formula.

M = IF(120>=MAX(Table2[m]) && 5>=MAX(Table2[c]) ,1,0)

 

 


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.