Forum Discussion

pawelj795's avatar
pawelj795
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?
Need Help
Show and Tell
Tips and Tricks
  • az38's avatar
    az38
    6 years ago

    pawelj795  🙂

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

RETURN
IF(ISBLANK(VVR); "Undefined"; MID(Warehouse[Item Name]; VVS+4; 3))
pawelj795's avatar
pawelj795
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's avatar
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's avatar
    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's avatar
      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))
      • pawelj795's avatar
        pawelj795
        Post Prodigy
        6 years ago

        az38 

        Unfortunately, it's not working