Forum Discussion

RalphyDaddy's avatar
RalphyDaddy
Frequent Visitor
1 year ago
Solved

Split or delimit column based on IF statement

Hi, not sure if this is possible. I have a table that contains 2 columns (Level and Model). I need the information inside the Model column, however it's positioning differs on the level.   Below ...
Need Help
  • ExcelMonke's avatar
    ExcelMonke
    1 year ago

    Hello,

    Yes, this is possible. I would consider using transform to accomplish this. In transform, add a custom column with the following M language:

    if [Level] = 1 then Text.Middle([Model],2,2) else Text.Middle([Model],4,2)

    I used it to get this:

     

    Hope this helps! 

v-hashadapu's avatar
v-hashadapu
Community Support
1 year ago

Hi RalphyDaddy ,
I wanted to follow up and see if you’ve had a chance to review the information provided here.
If any of the responses helped solve your issue, please consider marking it "Accept as Solution" and giving it a 'Kudos' to help others easily find it.
Let me know if you have any further questions!