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

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