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