pawelj795Post Prodigy6 years agoSolvedRow 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? Show Moreaz38 to pawelj7956 years agopawelj795 🙂 TEST= var VVS = SEARCH("VVS"; Warehouse[Item Name]; 1; BLANK()) RETURN IF(ISBLANK(VVR); "Undefined"; MID(Warehouse[Item Name]; VVS+4; 3))
az38 to pawelj7956 years agopawelj795 🙂 TEST= var VVS = SEARCH("VVS"; Warehouse[Item Name]; 1; BLANK()) RETURN IF(ISBLANK(VVR); "Undefined"; MID(Warehouse[Item Name]; VVS+4; 3))
az38 to pawelj7956 years agopawelj795 🙂 TEST= var VVS = SEARCH("VVS"; Warehouse[Item Name]; 1; BLANK()) RETURN IF(ISBLANK(VVR); "Undefined"; MID(Warehouse[Item Name]; VVS+4; 3))
az38Community Champion to pawelj7956 years agopawelj795 🙂 TEST= var VVS = SEARCH("VVS"; Warehouse[Item Name]; 1; BLANK()) RETURN IF(ISBLANK(VVR); "Undefined"; MID(Warehouse[Item Name]; VVS+4; 3))
Related contentIf text column CONTAINS specified value, give me what I wantCheck if column contains ONLY specified valueContain WordCount rows containing valueData source error: Value was not specified..
