Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Return all rows for which column contains specific keyword

I have a table with Title column. I need to return all rows for which Title Contains "Keyword".   Do I need to return a new CALCULATETABLE for this?  Please help me with DAX ?  Thanks   
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
    This worked though 🙂 
    FILTER(Workitems, CONTAINSSTRING(Workitems[Title], "[Reg"))
     
     
Anonymous's avatar
Anonymous
Not applicable
6 years ago
This worked though 🙂 
FILTER(Workitems, CONTAINSSTRING(Workitems[Title], "[Reg"))
 
 
JarroVGIT's avatar
JarroVGIT
Icon for Resident Rockstar rankResident Rockstar
6 years ago
Good to hear my solution worked, although I didn't understood you wanted a calculated table as a result 🙂