Forum Discussion

Sime's avatar
Sime
Helper I
4 years ago
Solved

Table Value Comparison

Hi All,   I would like to compare the values of a column (same data) from 2 different tables and flag the unique values in a conditional column in the dataset so they can be filtered out.   Basic...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Sime ,

     

    You can create a custom column in table 2 with below code:-

    column =
VAR result =
    CALCULATE (
        FIRSTNONBLANK ( '__Table 1'[ColumnProject], 1 ),
        FILTER (
            ALL ( '__Table 1' ),
            '__Table 1'[ColumnProject] = '__Table 2'[ColumnProject]
        )
    )
RETURN
    IF ( ISBLANK ( result ), "Existing Project", "new project" )

     

    Thanks,

    Samarth

     

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Sime ,

 

You can create a custom column in table 2 with below code:-

column =
VAR result =
    CALCULATE (
        FIRSTNONBLANK ( '__Table 1'[ColumnProject], 1 ),
        FILTER (
            ALL ( '__Table 1' ),
            '__Table 1'[ColumnProject] = '__Table 2'[ColumnProject]
        )
    )
RETURN
    IF ( ISBLANK ( result ), "Existing Project", "new project" )

 

Thanks,

Samarth

 

  • Sime's avatar
    Sime
    Helper I
    4 years ago

    Thank you very much for your assistance Samarth_18 .  This worked as anticipated.