Forum Discussion
PuddleRunna
5 years agoAdvocate I
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...
- 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] )
PuddleRunna
5 years agoAdvocate I
Awesome, thanks for the fast help š