Forum Discussion

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 ...

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!

Super User

1 year ago

besides the solution in pq, you can also use DAX to create a calculated column

Column = IF('Table'[Level]=1,mid('Table'[Model],3,2),mid('Table'[Model],5,2))