DAX to use LIKE statement

[jaryszek]

Hi Guys,

i have dax like here:

Day 9 = 
    CALCULATE(
        AVERAGEX(
            VALUES(
                Orders[OrderID]),
                [Total sales]
        ),
    FILTER(
        Customers,
        Customers[CompanyName] = "Romero y Tomillo"
    )
    )

and what i want to use is to get Customers[CompanyName] LIKE "Romero*",
how to do this in DAX?

Best,
Jacek

[shephaliB · Accepted solution]

Hi Jacek,

Try using below as a filter condition:

CONTAINSSTRING('Customers'[CompanyName], "Romero")

Thanks,

Shephali

[jaryszek]

oo great! 

thank you!