Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Nested If Q

I am trying to find out how to get the desired results.  In my TEST_TABLE, the USED column is what I want to place my results.  If there is a value in the ENQ or VAR column I want it flagged as TRUE.  I am sure this is a nested IF statement, but I am very new to Power BI. Any help is greatly appreciated.

 

if statement q.PNG

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

 

Try this calculated column formula

 

=OR(ISNUMBER(Data[ENQ]),ISNUMBER(Data[VAR]))


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

 

Try this calculated column formula

 

=OR(ISNUMBER(Data[ENQ]),ISNUMBER(Data[VAR]))


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Seward12533
Solution Sage
Solution Sage

Using a calculated column

Used = IF([ENQ]||[Var],True,False)

If you want the text TRUE or FALSE rather than the Boolean put them in quotes.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.