FALSE

Applies to: Calculated column Calculated table Measure Visual calculation

Returns the logical value FALSE.

Syntax

FALSE()

Return value

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`

TRUE function NOT function IF function

Atsauksmes

Vai šī lapa palīdzēja?

Last updated on 2024-04-25