Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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 ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

If there has existed a one to one or many to one relationship between table 'Device' and 'VirtualDevice', you can create calculated columns using below DAX in 'Device'.

Visa = RELATED(VirtualDevice[visa-versa])
Label = IF(Device[Device Label]=BLANK(),RELATED(VirtualDevice[Virtual Label]),Device[Device Label])

 

If you have created a many to one relationship or there is no relationship between these two tables, you could CrossJoin two tables to combine them into a single one, then filter rows based on some rules. If possible, please share some sample data stored in these two tables and show us an example of your desired result so that I can test for you.

 

Regards,
Yuliana Gu