Stumped by Simple Calculated column - if statement with variant types text and number

[doubleclick]

Does anyone know how to do this excel formula in DAX?

= if ([Text Column] = "Alpha",[Number Column]*8,"")

[v-angzheng-msft]

Thank you for sharing

Glad to hear that your problem has been fixed

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[doubleclick · Accepted solution]

Hey all, I was being a little slow. Long day. ContainsString() and blank() fixed this