New column creation

[Haidarius]

Hello,

So I have tables A,B and C where

A and B have a relationship through a column and A has another column with True or blank values

I am trying to create a new column using:

NEWCOLUMN = IF(RELATED(A[relationshipcolumn])="True",1) 

so I can then create another column in table C based on this new column since I cannot create the column where tables A and C are unrelated. 

When creating this NEWCOLUMN I am getting the following error:

"DAX comparison operations do not support comparing values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."

Any help is appreciated, thank you.

[ryan_mayu · Accepted solution]

@Haidarius 

maybe you can try this

NEWCOLUMN = IF(RELATED(A[relationshipcolumn])=True(),1) 

[parry2k · Accepted solution]

@Haidarius or you don't need to compare value for true, you can further enhance it

NEWCOLUMN = IF(RELATED(A[relationshipcolumn]),1) 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[ryan_mayu · Accepted solution]

@Haidarius 

maybe you can try this

NEWCOLUMN = IF(RELATED(A[relationshipcolumn])=True(),1)