Forum Discussion

Post Prodigy

6 years ago

Solved

Row contains specified value

Hi, I have a column like below. I want to return rows which contain let's say VVS150. How to do this?

6 years ago

TEST= 
var VVS = SEARCH("VVS"; Warehouse[Item Name]; 1; BLANK())

RETURN
IF(ISBLANK(VVR); "Undefined"; MID(Warehouse[Item Name]; VVS+4; 3))

Post Prodigy

6 years ago

az38
Now error dissappear 😉

Moving to the next.

I want to return respectively 180,100,075,075,021,040 -> How to modify my function?

Community Champion

6 years ago

TEST= 
var VVS = SEARCH("VVS"; Warehouse[Item Name]; 1; BLANK())

RETURN
IF(ISBLANK(VVR); "Undefined"; MID(Warehouse[Item Name]; VVS+3; 3))

Community Champion

6 years ago

TEST= 
var VVS = SEARCH("VVS"; Warehouse[Item Name]; 1; BLANK())

RETURN
IF(ISBLANK(VVR); "Undefined"; MID(Warehouse[Item Name]; VVS+4; 3))