Forum Discussion

Marija_JC's avatar
Marija_JC
New Member
1 year ago
Solved

Help with M code conditional column

Hello,  I woluld like to create an coditional column based on the text values from another column. So, it should be like: if column B has value " x", then text in column A sholud start from 4th cha...
Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

    use the following formula

    = 
if [ColumnB] = "x" then
    Text.Middle([ColumnA], 3) 
else if [ColumnB] = "y" then
    Text.BeforeDelimiter([ColumnA], "-") 
else if [ColumnB] = "z" then
    Text.BetweenDelimiters([ColumnA], "(", ")") 
else
    null
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Marija_JC ,

Thanks MarkLaf  for the clean and accurate solution  your logic perfectly aligns with the expected output shared by OP. 

Hey Marija_JC  did you get a chance to look at the solution above? It seems to cover all your conditions for "X", "Y" and "Z"exactly as described and shown in your screenshot. Let us know if it works as expected on your end or if you ran into any edge cases happy to help further.

Regards,
Akhil.