Forum Discussion

timoneill84's avatar
timoneill84
Frequent Visitor
8 years ago
Solved

Monthly Percentage

Hi all   I'm new to Power and have only done three of the tutorials so I apologise if the question has a simple answer!   How would I go about showing the total number of records / rows that read...
timoneill84's avatar
timoneill84
Frequent Visitor
8 years ago

Hi

 

I'm just trying to modify the check formula which currently reads:-

 

check = IF(ISERROR(SEARCH("4x4",Claims[Vehicle Type])),1,0)

 

How do I get it to search for multiple text criteria instead of just 4x4? so say search for 4x4 OR apples and return 0 next to those rows?

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
8 years ago

timoneill84，

This thread has been closed, please open a new thread about the new question.

Regards,
Lydia