Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a filed Job Description for example:
NGN NATRX272 - (Slough - Manchester)
STAGING OWL - BTWB100200 TeleCity Pr / Rugb Pr
And I have Group Portfolio:
OWL
NGN
EBD
LAPWING
I need a formula in another column that says where in description contains “OWL”, gives me OWL, where contains “EBD” gives me “EBD” and so on.
Solved! Go to Solution.
Hi @julianadeangelo ,
The suggestion of PattemManohar is helpful.
By my tests, you also could refer to the fomula below.
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @julianadeangelo ,
The suggestion of PattemManohar is helpful.
By my tests, you also could refer to the fomula below.
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
@julianadeangelo Please try with SEARCH function to check the patterns and SWITCH statement to return the final result. Any sample test data with atleast 10 rows will be helpful to provide you an accurate solution.
Proud to be a PBI Community Champion
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |