Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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?
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.
The final purpose is that I will count how many employees have 3 or more.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |