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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MrMarshall
Helper II
Helper II

Simple IF Causing error

IF-statement in it's simplest form is causing issues.

"Profit" is of datatype "Whole number". 

 

What's wrong here? Running desktop version 2.58.5103.501.

 

Screenshot_70.png

1 ACCEPTED SOLUTION

The problem was a missing White-space after "1000". 
I have never had any problems with it before.. 

This works ;o

 

Screenshot_71.png

View solution in original post

5 REPLIES 5
TomMartens
Super User
Super User

Hey,

 

I'm not sure, but do you need to use ";" instead of "," as a separator of arguments?

 

Check your regional settings at the OS level.

 

Regards

Tom 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Stachu
Community Champion
Community Champion

if this is calculated measure then 'Sales'[Profit] >1 is comparing a column (multiple values) with scalar, which won't work
this syntax should work fine for calculated column though



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

The problem was a missing White-space after "1000". 
I have never had any problems with it before.. 

This works ;o

 

Screenshot_71.png

you can have none or multiple whitespaces in the syntax, for sure that wasn't the reason for the measure not working



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

I agree it does look strange. 
But here I have two pictures taken a few seconds ago.

Must be some strange OS-culture bug.

 

Screenshot_74.pngScreenshot_73.png

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.