Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
doubleclick
Helper II
Helper II

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,"")

1 ACCEPTED SOLUTION
doubleclick
Helper II
Helper II

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

View solution in original post

2 REPLIES 2
v-angzheng-msft
Community Support
Community Support

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
Helper II
Helper II

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors