Forum Discussion

Saxon202202's avatar
Saxon202202
Icon for Helper III rankHelper III
3 years ago

Lookup reference multiple columns

Hello, I have two tables are data and report. In data table the following columns are Result, Reference1, Reference2. In report table the following columns are Reference1 and Reference2. I am try...
Need Help
katika555's avatar
katika555
Icon for Resolver I rankResolver I
3 years ago

Hi Saxon202202 

RETURN
If(isblank(RESULT1)&&NOT Isblank(RESULT2),RESULT2,RESULT3)
  • Saxon202202's avatar
    Saxon202202
    Icon for Helper III rankHelper III
    3 years ago

    katika555 ,
    Can you please explain what you suggested to me. I already created DAX code but it's not working but you gave me for if statement?