This topic has not yet been rated - Rate this topic

TRUE Function

SQL Server 2012

SQL Server 2008 R2

Returns the logical value TRUE.


TRUE()

Return Value

Always TRUE.

Remarks

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

Example

The formula returns the logical value TRUE when the value in the column, 'InternetSales_USD'[SalesAmount_USD], is greater than 200000.

The following table shows the results when the example formula is used in a PivotTable, 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())

Reference

FALSE Function

NOT Function

IF Function

Other Resources

DAX Function Reference

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD