Hi Fellow Power BI Users -
I have a search criteria table that I want to use to do a search for multiple conditions against in my main table
Using the below formula works well for a single text search criteria
=FIRSTNONBLANK(FILTER(VALUES( 'SearchC'[Search Criteria 1]) ,SEARCH('SearchC'[Search Criteria 1],'Data3-Work Order List'[Description],1,0)),1)
However Im stuck when trying to add another optional search criteria in another column of the SearchC Table ie: Search Criteria 2 as this formula doesn’t work when there are blank rows in the table
How would I be able to add ie: Looks for text containing Search Criteria 1 & Search Criteria 2?
Are you able to help point me in the right direction?