Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Compare two columns in two different tables

I have two tables. one called purchase request and the other called registration   on the purchase request, i have a column called invoice total. and on the regis table column called Regis total. ...
General Comment
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

The relationship between the two tables is established through the REGIS field and then the related function is used. The reference is as follows:

Column =
VAR COL_ =
    RELATED ( Registration[Regis Total] )
RETURN
    IF ( 'Purchase Request'[Invoice Total] = COL_, "Yes", "no" )

 

 

Best Regards,
Adamk Kong

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    i got thei error

     

    The column 'Logistics Center Report[RETAILTOTAL]' either doesn't exist or doesn't have a relationship to any table available in the current context.

     

    I used this as you stated

     

    Column =
    VAR COL_ =
        RELATED ( 'Logistics Center Report'[RETAILTOTAL] )
    RETURN
        IF ( 'REGIS'[REGIS TOTAL] = COL_, "True", "False" )