Forum Discussion

YoussefN's avatar
YoussefN
Regular Visitor
8 years ago

if function 3 conditions from different table

Hi,   I have two tables REFERENCE and CALL I want to add a conditional column to the table CALL with True and False based on three conditions. 2 of the conditions are in table CALLand 1 in TABLE RE...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI YoussefN,

 

You can try to use below measure:

result =
VAR _no =
    MAX ( tableCall[Order No.] )
VAR _work =
    MAX ( tableCall[Nr. of work] )
VAR _order =
    MAX ( tableCall[Nr of order] )
VAR related_point =
    LOOKUPVALUE ( TableReference[Reference point], TableReference[Oder No.], _no )
        + 0
RETURN
    IF ( related_point = 70 && _work = 1 && _order = 1, TRUE (), FALSE () )

Regards,

Xiaoxin Sheng