Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

value compare different column in same table

i have table name  called  Master file.My data table looks like below.  i want compare the values .if  IN_table ,Out_Table ,Eo_In_table , Eo_Out_table ,CMN   all same its return TRUE .  if Not matach...
Help me
Help me please
Help Requested
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    Hi,

    Here is a pretty straightforward way to do this (albeit not the most elegant):

    Test Match =
    var col1 = SELECTEDVALUE('Table (3)'[Column1])
    var col2 = SELECTEDVALUE('Table (3)'[Column2])
    var col3 = SELECTEDVALUE('Table (3)'[Column3])
    var col4 = SELECTEDVALUE('Table (3)'[Column4])


    return

    IF(col1=col2&&col2=col3&&col3=col4,TRUE(),FALSE())
     
    Data:

    End result:


    I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!

ValtteriN's avatar
ValtteriN
Community Champion
4 years ago

Hi,

Here is a pretty straightforward way to do this (albeit not the most elegant):

Test Match =
var col1 = SELECTEDVALUE('Table (3)'[Column1])
var col2 = SELECTEDVALUE('Table (3)'[Column2])
var col3 = SELECTEDVALUE('Table (3)'[Column3])
var col4 = SELECTEDVALUE('Table (3)'[Column4])


return

IF(col1=col2&&col2=col3&&col3=col4,TRUE(),FALSE())
 
Data:

End result:


I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!