Forum Discussion
IF TableA.Label is Blank Return TableB.Label Else Return TableA.Label
Hi, I have 2 unrelated tables by relationship, but in terms of values there is some form of relationship. I Need to create a column (Or Measure) that will return all the rows. To understand a bit ...
Hi there,
Happy to help. Couple of clarifying questions. Is there already a relationship between the two tables, and if yes do you know the type (E.g. One-to many, one-to-one, etc...) If there is already a relationship you should be able to create a column with a formula similar to below:
= IF ( Device[Label] = BLANK (), VirtualDevice[Label], Device[Label] )
Reid Havens - Owner