Forum Discussion
Validating Combination between two columns
Hi there, dumb question... I have a table with columns "Class" and "Tag". I'd like to get a measure (or a calculated column) called validation... the validation would be:
if 'Class' = Vessel and 'Tag' = V than result is 1, otherwise 0.
thanks!
Hello Anonymous ,
use the following as Calculated Column
Validation = IF('Table'[Class] = "Vessel" && 'Table'[Tag] = "V",1,0)If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
2 Replies
Hello Anonymous ,
use the following as Calculated Column
Validation = IF('Table'[Class] = "Vessel" && 'Table'[Tag] = "V",1,0)If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Idrissshatila Solution worked perfectly. Thanks!