Forum Discussion
Solved
PowerBI Dax Formula, returning text from column with 3 different return options
Hi, I am struggling to find the right formula to return the text I need to a new column in PowerBI. This is what I need If Column A = "z" then return "Opex" If Column A = isblank then return "tb...
Hi, in the power query, add a custom column and the following
if [Column A] = "z" then "Opex" else if [Column A] = "" then "tbc" else if [Column A] <> "z" then "Capex" else if [Column A] <> "" then "Capex" else "Capex")or you can use DAX, add a column
if(Table1[Column A] = "z", "Opex",if([Column A] = "", "tbc", if( [Column A] <> "z" || [Column A] <> "" , "Capex")))
Hi, in the power query, add a custom column and the following
if [Column A] = "z" then "Opex" else if [Column A] = "" then "tbc" else if [Column A] <> "z" then "Capex" else if [Column A] <> "" then "Capex" else "Capex")
or you can use DAX, add a column
if(Table1[Column A] = "z", "Opex",if([Column A] = "", "tbc", if( [Column A] <> "z" || [Column A] <> "" , "Capex")))