FALSE

Updated on

Syntax

FALSE( )

Return Values

Always FALSE.

Remarks

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

Example

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

= IF(SUM('InternetSales_USD'[SalesAmount_USD]) >200000, TRUE(), false())

The following table shows the results when the example formula is used with ‘ProductCategory'[ProductCategoryName] in Row Labels and ‘DateTime'[CalendarYear] in 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

Other functions related to FALSE are:

Contribute » | Contributors: Rick de Groot

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy