cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sunb1 Frequent Visitor
Frequent Visitor

Using OR in a RELATED calculated column - return value based on two related tables

Hi - PLEASE HELP!! Smiley Happy

i have two lookup tables connected to a data table. Both can get me the column i want in the data table (ie, INDUSTRY), but through different relationships. Can I use the OR function in a RELATED calculated column so that it will retrieve the correct INDUSTRY based on EITHER lookup table 1 or lookup table 2?

 

 

Thank you!!!

1 ACCEPTED SOLUTION

Accepted Solutions
sunb1 Frequent Visitor
Frequent Visitor

Re: Using OR in a RELATED calculated column - return value based on two related tables

So that's the approach i took, but i had to to do two calculated columns using RELATED and then a final column with an IF statement, saying if the answer is not satisfied from the first column, then use the second column. 

4 REPLIES 4
Highlighted
Super User
Super User

Re: Using OR in a RELATED calculated column - return value based on two related tables

I dont think you can use OR function in RELATED function.

mnayar Established Member
Established Member

Re: Using OR in a RELATED calculated column - return value based on two related tables

@sunb1 try using variables to get this

Industry col final =

var ind1 = related(table 1 industry)

var ind2 = related(table 2 industry)

return if(condition, ind1,ind2)

 

if it is driven by filters then it will have to be a measure.

sunb1 Frequent Visitor
Frequent Visitor

Re: Using OR in a RELATED calculated column - return value based on two related tables

So that's the approach i took, but i had to to do two calculated columns using RELATED and then a final column with an IF statement, saying if the answer is not satisfied from the first column, then use the second column. 

mnayar Established Member
Established Member

Re: Using OR in a RELATED calculated column - return value based on two related tables

@sunb1 hey just curious, isn't my ans the accepted solution to your problem?