Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Extract Text

Hi, I have few Product descriptions with me eg: HP 16GB (1X16GB) 2RX4 PC3L-12800R HP 16GB(1X16GB) 2RX4 PC3L-12800R HPE 16GB 1RX4 PC4-2400T-R DIMM 16GB PC4-2933 DUAL-RANK X8 DDR4 8GB PC4-2933 SIN...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    power Query, add Conditional column 

     

az38's avatar
az38
Community Champion
6 years ago

Anonymous 

For DAX you can use calculated column

Memory Column = 
VAR GbStart = SEARCH("GB", [Column1])
VAR PrevSpace = SEARCH(" ", [Column1]) + 1
VAR StartPosition = IF(PrevSpace > GbStart, 1, PrevSpace)
VAR TextLen = GbStart - StartPosition + 2
RETURN
IF(StartPosition = 0, LEFT([Column1], TextLen), MID([Column1], StartPosition, TextLen ))