Forum Discussion
DAX query, Creating new coulmns
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
2 Replies
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.
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" )@
