Table search function with modifier (Qlik reference)

baneworth — Mon, 29 Jun 2020 07:37:16 GMT

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,

Re: Table search function with modifier (Qlik reference)

lbendlin — Tue, 30 Jun 2020 14:34:23 GMT

use the FIND() or SEARCH() functions.

topic Re: Table search function with modifier (Qlik reference) in DAX Commands and Tips

Table search function with modifier (Qlik reference)

Re: Table search function with modifier (Qlik reference)