Table search function with modifier (Qlik reference)

[baneworth]

Hello,

i am very new to Power BI, so please excuse me refering to Qlik for better explanation. When you look at the screenshot you can see that i used the * symbol to return all values starting with Altus since i did not want to write them all down manually.

goes like

-AltusMax

-AltusLFW

-AltusLFWMod

-....

I have to create exact Dax in power bi and for now i can't figure out a way which lets me do same or similar approach.

It works if i write them down manually obviously but that would be a pain.

So far my Dax looks like this:

next i would add another Filter which should include the Altus step explained above, is there a way to do that?

Best regards,

[lbendlin]

use the FIND() or SEARCH() functions.