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 |
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for