Multiple columns comparison with a measure or calculated column.

Hi adelmonte ,

 

Currently you want to compare multiple pairs of columns in one table. Your logic is if Colum1[Value] = Colum2[Value] then True else False. However Power Query, Dax only support you to compare determind columns instead of dynamic columns. So you need to determind column1 and column2 in your code. Only one measure couldn't compair all pairs of columns. 

Here I suggest you to add an Index column in your table then use unpivot function to transform your table.

After transformation, my Sample looks like as below.

Create a measure.

Compare pair of columns = 
VAR _ADD =
    ADDCOLUMNS (
        ALL ( 'Table' ),
        "Left", LEFT ( [Column Header], 2 ),
        "Right", RIGHT ( [Column Header], 2 )
    )
VAR _ADD1 =
    ADDCOLUMNS (
        _ADD,
        "01",
            IF (
                [Right] = "02",
                MAXX (
                    FILTER (
                        _ADD,
                        [Index] = EARLIER ( [Index] )
                            && [left] = EARLIER ( [Left] )
                            && [Right] = "01"
                    ),
                    [Value]
                ),
                BLANK ()
            )
    )
VAR _ADD2 =
    ADDCOLUMNS (
        _ADD1,
        "TRUE/FALSE",
            IF ( [Right] = "02", IF ( [Value] = [01], "True", "False" ), BLANK () )
    )
RETURN
    MAXX (
        FILTER (
            _ADD2,
            [Index] = SUM ( 'Table'[Index] )
                && [Column Header] = MAX ( 'Table'[Column Header] )
        ),
        [TRUE/FALSE]
    )

Create a matrix visual. We only need measure result next column02, so turn off word wrap in Format and reduce the width of measure result for column01 to 0. Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.