I am having some trouble with implementing a measure.
Essentially, I want PowerBI to see if there is a certain string in each link, and if so, return a value.
For example, using the sample below:
If a URL contains
Penguins = PEN
Koala = KOA
Gorilla = GOR
FISH = FIS
I want the output to return:
I know you can use the SWITCH function, or the IF Function with CONTAINSSTRING if I was to create a column (which I can't because we use direct query). I also know to get the ^ above output, I need to add some row context, but I can't identify an iterator function that would be appropriate.
Is there a solution here? or should I rebuild by using IMPORT and then add columns.
Thank you very much! Would appreciate any clear instructions as I'm a PowerBI newbie.