Forum Discussion
Using OR in a RELATED calculated column - return value based on two related tables
Hi - PLEASE HELP!! :)
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!!!
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
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.
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.
sunb1 hey just curious, isn't my ans the accepted solution to your problem?
