Forum Discussion

STs2207's avatar
STs2207
Frequent Visitor
8 years ago
Solved

If then else old value

Hi,   I would like to transform the data in one column as follows but cannot find a way to do it. I want to find the cells that start with abc and replace the content of the cell with abc, otherwis...
  • Interkoubess's avatar
    Interkoubess
    8 years ago

    Hi STs2207,

     

    You can use this formula in Query Editor for power Query or use the LEFT function in DAX :

     

    if Text.Contains([Column2], "abc") then "abc" else [Column2])

    Hope it helps...

     

    Ninter

     

Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

Hi STs2207,

 

You can use this formula in Query Editor for power Query or use the LEFT function in DAX :

 

if Text.Contains([Column2], "abc") then "abc" else [Column2])

Hope it helps...

 

Ninter