Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
5 years ago
Solved

Matching Columns in 2 Tables

Dear All   I need your help.   I have two tables as below.  In table 1 I have the data and in table 2 staff updates all the information.   Requirement From Table 2 identify the first characte...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    5 years ago

    gauravnarchal ,

    new column in table 2= maxx(filter( Table1, Table2[Code] = Table1[Code] && Table1[Category] = left(Table2[Identifier],1)),Table1[Shipping])

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Step 1create a calculate column
Dax
CodeCom=[Code] &"" &[Category]

Step2. create another calculated column

Dax
CodeCom2=[Code] &""& LEFT([IENTIFIER,1)


and make a relationship between these tables using above new column CodeCom and CodeCom2

Then you can directly pull the column in the visual or you can use related function in the 2 nd table.