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 REFERENCE.

 

The conditions are If the value of the field Nr. of work = 1 and the value of the field Nr of order = 1 and the field reference point in table REFERENCE = 70 then the value should be true and else FALSE

 

How can I do this?

 

Thanx in advance

 

example table

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Have a look at the LOOKUPVALUE function or RELATED or RELATEDTABLE.

  • 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