Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

If Statement/ Related Formula assistance

Wanting to create a formula that essentially does a vlook up across fields. Trying to create an out put that would show if the data from table A matches table B, would be great to generate a yes or no outcome.
 
Below is the latest formula I have tried but getting the error message "Function RELATED expects a fully qualified column reference as its argument. "
 
If(RELATED('Previous Report'[Concat2]='Export'[concat2]),1,0)
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    If you are making it as a new column in "Export" table and there is a relationship between "Export" and "Report" then change the statement to :

     

    If(RELATED('Previous Report'[Concat2])='Export'[concat2],1,0)

     

    Only 1 parenthesis in the wrong place :)

     

    /Adrian

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    If you are making it as a new column in "Export" table and there is a relationship between "Export" and "Report" then change the statement to :

     

    If(RELATED('Previous Report'[Concat2])='Export'[concat2],1,0)

     

    Only 1 parenthesis in the wrong place :)

     

    /Adrian

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      It looks like the extra ")" did the trick. Thanks for catching that.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous,

         

        If the answer is what you want, could you please mark it as "Acceptable Solution"?

         

        So other people will know the question is solved.

         

        Thanks.

        Aiolos Zhao

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous,

     

    I think you may try to use LOOKUPVALUE function.

    For your sample, the calculated column may look like:

     

    Column = IF(ISBLANK(LOOKUPVALUE('Previous Report'[Concat2],'Previous Report'[Concat2],'Export'[concat2],"NO")),0,1)

     

    Please try.

    Aiolos Zhao