TRUE Function (DAX)

How does the TRUE function (DAX) work?

The TRUE function (DAX) returns the logical value TRUE.

TRUE Formula Syntax

TRUE(
     
)

How do you use the TRUE function?

It is a very useful function when you want to return the output as TRUE based on a condition. A TRUE function is the same like Boolean value TRUE. It’s also called a conditional function.

A TRUE function can be used with other logical functions like IF, ERROR etc.

Related Blog Posts

Related Support Forum Posts

SWITCH True Logic Explained
FTE Calculation after Switch True Logic
Switch True with measure between range values

Considerations when using the TRUE function

If you want to enter TRUE, or provide TRUE as a result in a formula, you can just use enter the word TRUE directly into a cell or formula and Excel will interpret this as the logical value TRUE.

Also note that logical expressions themselves will automatically generate TRUE and FALSE results.

Related Video Tutorials

Formula examples using the TRUE function

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

=IF(A1<0, TRUE())

=IF(A12>30,TRUE())

Related DAX Functions

FALSE
NOT
IF

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership