Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Icon for Helper V rankHelper V
5 years ago
Solved

IF statement not working

Hi,   Im trying to write a simple if stamenet but it doesn't work with numbers or measures. IF(SUM('table1'[Column1]) = 50000,1,2) --> Doesnt work. Says "Too few arguments were passed to the ...
Need Help
  • CarlsBerg999's avatar
    CarlsBerg999
    5 years ago

    Actually this got fixed with putting an additional space. For example 50000 , ValueIfTrue

    Before i had 50000,ValueIfTrue

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi CarlsBerg999 

There's nothing syntcatically wrong with your first version

 

IF(SUM('table1'[Column1]) = 50000,1,2)

 

So it must be something else.  Is this the entirety of the code?

What is your decimal separator?  Comma or period?  

regards

Phil

CarlsBerg999's avatar
CarlsBerg999
Icon for Helper V rankHelper V
5 years ago

Actually this got fixed with putting an additional space. For example 50000 , ValueIfTrue

Before i had 50000,ValueIfTrue