CODEWITHSUNDEEP
powerbi
Ranjit Singh
Ranjit Singh

Reputation: 23

powerBi, Split the column to separate columns in order

enter image description here

Please help in getting the column splitted in the required format.

Upvotes: 0

Views: 54

Answers (1)

karlis ssl
karlis ssl

Reputation: 143

You could add a new column, when in Powerbi right click table, select New column add 3 new columns

A= if(CONTAINSSTRING([projects],"A"),1,0)

B= if(CONTAINSSTRING([projects],"B"),1,0)

C= if(CONTAINSSTRING([projects],"C"),1,0)

Upvotes: 0

Related Questions