Forum Discussion

Icon for Post Prodigy rank

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?

Tips and Tricks

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))

Icon for Community Champion rank

Community Champion

6 years ago

try to replace BlANK() to 0 in your var statement - MID should have a digit second argument, BlANK() will provide an expected error

or try to obtain MID in if like

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

Icon for Post Prodigy rank

Post Prodigy

6 years ago

az38
Your first solution return same error.

But I can't understand your second idea.

What VVR and "Undefined" in your statement mean?

az38
Community Champion
6 years ago
pawelj795

it will check - if VVR returns BLANK() value then column wll be equal "Undefined" or anything you want instead. If VVR returns digit it will execute MID() function
- pawelj795
  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?
  - az38
    Community Champion
    6 years ago
    ok
    
    pawelj795
    
    TEST= var VVS = SEARCH("VVS"; Warehouse[Item Name]; 1; BLANK()) RETURN IF(ISBLANK(VVR); "Undefined"; MID(Warehouse[Item Name]; VVS+3; 3))

Related content