Forum Discussion

MHTANK's avatar
MHTANK
Helper III
2 years ago
Solved

Split column as per specific condition

This is my data: I want this result:      Explanation : When Y= no bgm then X column split as per result(2nd photo), only split by one character, where the last character is "B" or...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi MHTANK 

    In Power Query, create a custom column and paste the below code 

     

    = if [Y]="no bgm" then Text.Start([X],1) else [X]

     


    If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush