Forum Discussion
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 ...
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!
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!