Nested If Q

[Anonymous]

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.

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

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

[Seward12533]

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.