Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

FALSE Function

Returns the logical value FALSE.


FALSE()

Always FALSE.

The word FALSE is also interpreted as the logical value FALSE.

The formula returns the logical value FALSE when the value in the column, 'InternetSales_USD'[SalesAmount_USD], is less than or equal to 200000.

The following table shows the results when the example formula is used with 'ProductCategory'[ProductCategoryName] in Row Labels and 'DateTime'[CalendarYear] in Column Labels.

True-False

Column Labels

 

 

 

 

 

Row Labels

2005

2006

2007

2008

 

Grand Total

Accessories

FALSE

FALSE

TRUE

TRUE

FALSE

TRUE

Bikes

TRUE

TRUE

TRUE

TRUE

FALSE

TRUE

Clothing

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

Components

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

 

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Grand Total

TRUE

TRUE

TRUE

TRUE

FALSE

TRUE

=IF(SUM('InternetSales_USD'[SalesAmount_USD]) >200000, TRUE(), false())
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.