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 table regarding Software (Table1) uses "SoftwarePackageFullName" though, e.g.

Teams 1.0_DE 1.0

Teams 2.2_DE 1.0

Whiteboard 2.32_DE 1.3

MS Project 2013_DE 1.2

 

Now I'd like to create a custom column in table 2 that takes the string in SoftwarePackage, checks SoftwarePackageFullName and returns the full name.

 

Can someone point me in the right direction? Probably something with CONTAINSSTRING?

 

Need Help
  • Fowmy's avatar
    Fowmy
    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]
)

     

     

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    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]
)