Forum Discussion
Solved
New Column not working
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: Column name: Withdrawn IF: [Approved_Refused_Other] is Withd...
Hello 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 |
Hi AmberGardner ,
Have a good day. Did the above reply help you resolve your issue? If so, please consider marking it as a solution. Thank you!
Best Regards,
Wearsky