Forum Discussion

Haidarius's avatar
Haidarius
Frequent Visitor
4 years ago
Solved

New column creation

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.

Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    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!

2 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    Haidarius 

    maybe you can try this

     

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

     

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    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!