DAX Function Guide

NOT
Empty image or helper icon

Sam McKay

CEO & Founder

How does the NOT work?
The NOT function (DAX) returns the opposite of a given logical or boolean value. When given TRUE, NOT returns FALSE.When given FALSE, NOT returns TRUE.
NOT Formula Syntax

NOT(
     <logical>
)

How do you use the NOT?

Use the NOT function to reverse a logical value.

Related Blog Posts

Loading

Considerations when using the NOT?

If the logical_value is TRUE, then the NOT function will return FALSE.
If the logical_value is FALSE, then the NOT function will return TRUE.

Related Video Tutorials

Loading

Formula examples using the NOT

=NOT([CalculatedColumn1])

=NOT(TRUE)

=NOT(A2=”Microsoft”)

Related Courses

Loading