Compare Values across columns in table

[Anonymous]

Hi,

I wish to compare 3 columns of values in a table and return a True/False if they all match.

I am using the following formula:

NewColumn = Table1[Column1]=Table1[Column2] && Table1[Column1]=Table1[Column3] && Table1[Column2]=Table1[Column3]

This works if all 3 columns have a value. But i want it to ignore blanks e.g.

Column1	Column2	Column3	NewColumn
7	7	7	TRUE
7	8	7	FALSE
8	8	7	FALSE
7	7		TRUE
	7		TRUE

[AlB · Accepted solution]

Hi @Anonymous 

NewColumn =
(
    Table1[Column1] = Table1[Column2]
        || ISBLANK ( Table1[Column1] )
        || ISBLANK ( Table1[Column2] )
)
    && (
        Table1[Column1] = Table1[Column3]
            || ISBLANK ( Table1[Column1] )
            || ISBLANK ( Table1[Column3] )
    )
    && (
        Table1[Column2] = Table1[Column3]
            || ISBLANK ( Table1[Column2] )
            || ISBLANK ( Table1[Column3] )
    )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

Thank for the quick reply.  Just checked and it works!