Forum Discussion
Power Query, Split Columns into Columns Conditinally
Hi, MagdoulinShams1
Thanks for the reply form Ashish_Mathur and audreygerred. You can try to use the Split Column function directly.= Table.SplitColumn(#"Changed Type", "Delivery status", Splitter.SplitTextByDelimiter("/", QuoteStyle.Csv), {"Status", "Count"})Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Super UserHi! It's ok - let the split happen on everything. Then, add a conditional column and do something similar to the below. You would say that if one column contains a /, return the value in column A, if it does not, return column B.
I hoped to reach the desired outcome in one step, but this is a good suggestion too.
