Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (11.1k points)

I am using IF ELSE query in Power Bi

=IF(([Status]=100000004),"hello","world")

and its not working instead I am getting the following error 

Expression.Error: The name 'IF' wasn't recognized. Make sure it's spelled correctly.

1 Answer

0 votes
by (22.5k points)

Use the below syntax

if([Status]=100000004) then "Open" else "Close"

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification  

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Nov 4, 2020 in BI by Sudhir_1997 (55.5k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...