Forum Discussion
How to split a column based on values
I am looking to split a column, (pictured below) but I only need to split certain values in the column. If the value starts with 1 I would like a split at the space, But values that do not st...
Anonymous , I you may have to use two-three steps in power bi.
Split into column based on last occurrence -
you will get Column 1, column 2
column 3 = if [column2] = null then [column1] else [column2]