New Column not working

Question

Hi i am currently trying to get a new column on my report that shows if these cases were withdrawn. Basically what i need is below:&nbsp;&nbsp;Column name: WithdrawnIF: [Approved_Refused_Other] is Withdrawn then return "Yes", else return "No&nbsp;Obviously i know that the above isnt going to work because it is massively incorrect and not the right format for the column, but this is the information that i need to pull and for some reason it is not working for me on PowerBI.&nbsp;&nbsp;If someone could also explain how to expand on this, such as: If XXX then return XXX, else if YYY then return YYY, else return ZZZ, that would be amazing thank you! ❤️&nbsp;I am still very new to this and am still learning, so i understand that this may seem like a stupid question but its something that i cant wrap my head around!

uzuntasgokberk · Accepted Answer

Hello&nbsp;AmberGardner,You can use Power Query(Transform Data) or DAX(New Column):PQ example:if [column] = 4 then "A"else if [column] = 2 then "C"else "B"DAX(new column) example:IF('Y Axis'[Y Axis] = 1,"A",IF('Y Axis'[Y Axis] = 2,"C","B"))
Kind Regards,Gökberk Uzuntaş📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!🔗 Stay Connected:📘 Medium |📺 YouTube |💼 LinkedIn |📷 Instagram |🐦 X |👽 Reddit |🌐 Website |🎵 TikTok |

Forum Discussion

New Column not working

2 Replies

Related content

Need column to return date in working days from today, from query table column.

Column Level OneLake Security - Not Working with shortcuts

MCP not working

New Column

Concatenate [column of values] & [text column.], Does not work!