Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
4 years ago
Solved

DAX to use LIKE statement

Hi Guys,   i have dax like here: Day 9 = CALCULATE( AVERAGEX( VALUES( Orders[OrderID]), [Total sales] ), FILTER( C...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Jacek,

    Try using below as a filter condition:

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

     

    Thanks,

    Shephali

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Jacek,

Try using below as a filter condition:

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

 

Thanks,

Shephali

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
4 years ago

oo great! 

 

thank you!