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 cel...
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"
)@