DAX Logical - TRUE function


Advertisements

Description

Returns the logical value TRUE.

Syntax

TRUE () 

Parameters

No parameters for this function.

Return Value

TRUE always.

Remarks

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

Example

= IF(AND([Country] = "USA",[Medal] = "Gold") = TRUE(),1,0)) 

Returns a calculated column with 1s for the rows with values USA in the column Country and Gold in the column Medal. Returns 0s for the rest.

dax_functions_logical.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements