Forum Discussion
Solved
Power Query, Split Columns into Columns Conditinally
I have the below step code: = if List.AnyTrue(List.Transform(#"Capitalized Each Word"[Delivery status], each Text.Contains(_, "/"))) then Table.SplitColumn(#"Capitalized Each Word", "Delivery sta...
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
Ashish_Mathur
Super User
Super UserHi,
Could you share some data to work with and show the expected result.