Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
@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]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Awesome, thanks for the fast help 🙂
@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]
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |