Forum Discussion
IF Statement Help
Hi Everyone:
I am creating a new column and I want the formula to give me blank if the "Result" column has null on it. WHat I'm doing wrong? I have been trying to fix the "else if" but it's pretty different than doing it on excel. :smileyindifferent:
- Power Query is Case sensitive. Give all IF in small i.e. if.
Use first query but give if in small.
5 Replies
hi jmuniz
Change "" to null in small case.
Hope that resolves the problem.
If this is the solution then do mark it as a solution and do click on the Upvote button.
Regards,
Pradip Microsoft Certified Trainer
Hi PradipMCT
After your recommendation I fixed the first part. To give you a background of my purpose of the new column is the following: If the numbers on the "Result" column is 3 or more, give me 1, if not, give me 0. However, since some of the numbers on the "Result" column are in blank, I want power bi to return those as blank also. :smileyhappy:
The final purpose is that I will count how many employees have 3 or more.
These are different formulas that I have been try to use but always get the "Token Eof expected".
IF [Result] =null then null else if [Result]>=3 then 1 else 0
if ([Result] =null, "",if([Result]>=3,1,0))
if [Result] = "" then "" else [Result]>=3 then 1 else 0
Any tips?
