Forum Discussion
Dax Error
Hai All Need help on this why this error is happening
The requirement is a user selects any year, He wants to see that year's value otherwise he wants to see sum value
AlanP514 Your first IF statement is broken. Why are you even using an IF statement there? IF statements need to have at least 2 arguments. You have 1 argument. Basically you are saying IF the DIVIDE of these two numbers then do nothing else do nothing. Can't work like that. Just drop the IF or decide what you want to return if true or false.
1 Reply
AlanP514 Your first IF statement is broken. Why are you even using an IF statement there? IF statements need to have at least 2 arguments. You have 1 argument. Basically you are saying IF the DIVIDE of these two numbers then do nothing else do nothing. Can't work like that. Just drop the IF or decide what you want to return if true or false.