Forum Discussion

ismael92's avatar
ismael92
Regular Visitor
3 years ago
Solved

Compare different tables

Good afternoon,   I am trying to compare two different tables with several columns:   Table1 with 20 columns Table2 with 20 columns   Both tables have a column with the same identificator.   ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  ismael92 ,

    I created some data:

    Table1:

    Table2:

     

     

    Here are the steps you can follow：

    1. Create measure.

     

    Flag =
var _1=
SUMMARIZE(
    'Table1','Table1'[ID],'Table1'[status],
    "Table2match",MAXX(
        FILTER(ALL(Table2),'Table2'[ID]=EARLIER('Table1'[ID])),[status]))
var _2=
ADDCOLUMNS(
    _1,"Flag",
    IF(
        [status]=[Table2match],"Match","Error"))
return
MAXX(
    FILTER(
        ALL('True'),
        'True'[ID]=MAX('Table2'[ID])),'True'[Flag])

     

    2. Result:

     

    Best Regards,

    Liu Yang

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

  • Anonymous's avatar
    Anonymous
    3 years ago

    Create Calculate Column
    Comp column = If(Related(Table1[Status]),=Table2[Status],"Match","Error")

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Create Calculate Column
Comp column = If(Related(Table1[Status]),=Table2[Status],"Match","Error")