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.
Hello, I'm trying to look in [Column] for the word "Scenario". If it finds it, I need to return "Scenario " + the next 2 characters. For example, the string may read "2040 3m Scenario 1 **DO NOT CHANGE**" and I need to return "Scenario 1"
Solved! Go to Solution.
Actually, I'll just look for Text.Contains "Scenario 1" or "Scenario 2" etc. That should do what I need, too. Sorry to bother!
Hi,
from this
to achieve this
you have to add a custom column
Text.Range([Column1], Text.PositionOf([Column1],"Scenario"),10)
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
Hi,
from this
to achieve this
you have to add a custom column
Text.Range([Column1], Text.PositionOf([Column1],"Scenario"),10)
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
That's perfect! Thanks so much for figuring this out for me!!
Actually, I'll just look for Text.Contains "Scenario 1" or "Scenario 2" etc. That should do what I need, too. Sorry to bother!
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.