DAX query, Creating new coulmns

[bug_rohit]

I have one column containing three type of values , i want to create three new columns each column containing distinct type of value which were there in first column, and having zero in all other cells .

Sample of data 

[Manoj_Nair]

@bug_rohit- Please check this out, let me know if this works. If this fix your problem, please tick this a solution and a thumps up.

COL2 = 
IF(
    TBL1[COL1] = "#NA",
    "#NA",
    "0"
)

COL3 = 
IF(
    TBL1[COL1] = "B",
    "B",
    "0"
)

COL4 = 
IF(
    TBL1[COL1] = "C",
    "C",
   "0"
)

@ 

[ToddChitt]

Since you are in the Power Query forum, this is a Power Query answer. You could probably also do something similar in DAX.

Create a Custom Column, named "Col 2" with a literal value of "0". Create another Custom Column named "Col 3" with this formula: if [Col1] = "B" then "B" else 0. Create Custom Column "Col4" with similar logic.