TRUE
Applies to: Calculated column Calculated table Measure Visual calculation
Returns the logical value TRUE.
Syntax
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.
= IF(SUM('InternetSales_USD'[SalesAmount_USD]) >200000, TRUE(), false())
The following table shows the results when the example formula is used in a report 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
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir