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