Forum Discussion

doubleclick's avatar
doubleclick
Icon for Resolver I rankResolver I
4 years ago
Solved

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

Does anyone know how to do this excel formula in DAX?   = if ([Text Column] = "Alpha",[Number Column]*8,"")
  • doubleclick's avatar
    doubleclick
    4 years ago

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

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
4 years ago

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.