Forum Discussion

PuddleRunna's avatar
PuddleRunna
Advocate I
5 years ago
Solved

Create new column, complete string with value from another table

Hi guys,   this one seems easy, but I'm not sure how to achieve it.   I have a dim table (Table2) with "SoftwarePackage" e.g. Teams 1.1.2 Teams 2.2 Whiteboard 2.34 MS Project 2013   My main...
  • Fowmy's avatar
    5 years ago

    PuddleRunna 

    Add the following New Column in Table 2 :

    Full Name = 
    
    MAXX(
    FILTER(
        'Table--1',
        CONTAINSSTRING('Table--1'[SoftwarePackageFullName] , 'Table--2'[SoftwarePackage])
    ),
    'Table--1'[SoftwarePackageFullName]
    )