Forum Discussion

CLEARIFY's avatar
CLEARIFY
Icon for Helper I rankHelper I
9 years ago

PowerBI Table.SplitColumn using conditional length of ranges

I have one column that I wish to split into two.    First column always has the first two characters.   Second column will start with the first character of the original column field based upon C...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi CLEARIFY,

 

I think you can add custom column to add separator to specific index of original text characters, then you can use split column function to deal with this data.

 

Regards,

Xiaoxin Sheng

  • CLEARIFY's avatar
    CLEARIFY
    Icon for Helper I rankHelper I
    9 years ago

    Thank you for both responses, but I think you guys are missing my bottom line question.  I can already create the columns I need, where a "third" column exists; very easy to do. 

     

    But my little pea brain tells me that there should be a way to do this is one step where only two resulting columns exist using the split column formula.