Forum Discussion
AlanP514
Post Patron
Post PatronDax error
Hai All, please help me to solve this error, I am trying to create a flag, but these two tables are in an inactive relationship, The logic is if the ambassador's name is present in the t1...
Hi AlanP514 ,
I created some data:
Ambassador:
T1:
Here are the steps you can follow：
1. Create calculated column.
Column = var _column=SELECTCOLUMNS('T1',"1",'T1'[User Name]) return IF( 'ambassador'[Name] in _column ,"Yes","No")2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi AlanP514 ,
I created some data:
Ambassador:
T1:
Here are the steps you can follow：
1. Create calculated column.
Column =
var _column=SELECTCOLUMNS('T1',"1",'T1'[User Name])
return
IF(
'ambassador'[Name] in _column ,"Yes","No")2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly