Forum Discussion
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 ...
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
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
It looks like the extra ")" did the trick. Thanks for catching that.