Forum Discussion

YerlaSDU's avatar
YerlaSDU
Icon for Helper I rankHelper I
3 years ago

Compare 2 columns and get same items with total

Hi Folks,

 

I have a 2 columns from 2 different tables and need to get same items from both and sum of them

As filter, I need to add conditions, where code are same, but CodeName is little different

 

How can I realize it?

 

Need Help

4 Replies

  • chilichill's avatar
    chilichill
    New Member
    3 years ago

    Hi,
    are the first 4 letters unique for each Code Name and identical in both tables? And what does the connection between the tables look like?

    • YerlaSDU's avatar
      YerlaSDU
      Icon for Helper I rankHelper I
      3 years ago

      chilichill 

       

      Code  4 letters is same for both, but codename may be different for the same Code. Connection is Many to One

      • chilichill's avatar
        chilichill
        New Member
        3 years ago

        Maybe try something like:

        Measure = 
VAR CodeTab1 = LEFT(MAX(Table1[Code Name]), 4)
VAR CodeTab2 = LEFT(MAX(Table2[Code Name]), 4)
RETURN
if(CodeTab1 = CodeTab2, SUM(Table1[Value]) + SUM(Table2[Value]), BLANK())