Validating Combination between two columns

[Anonymous]

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!

[Idrissshatila · Accepted solution]

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 👍

Follow me on Linkedin

[Anonymous]

@Idrissshatila Solution worked perfectly. Thanks!