Forum Discussion
Post ProdigySpliting column in to separate columns
Hello I am trying to split Information column in to 3 new columns that have only one value in each of them.
I hope attached image can show expected results better than my explanation.
Information is the original column and SplitA-B and C are results of split that I am trying to get.
I am sure it can be done but nothing I try so far seems to work.
Thanks.
I manage to do it using Conditional Column from Add Column tab in transform data.
2 Replies
- amitchandak
Super User
Justas4478 , You have to create new column like
Power query
if [information] ="Check-in Informtion" then "Check-in Informtion"
DAX
if([information] ="Check-in Informtion" ,"Check-in Informtion", blank())
create other columns like that
Justas4478I manage to do it using Conditional Column from Add Column tab in transform data.
