| « INFORMATION FUNCTIONS (DAX) | Math and Trig Functions (DAX) » |
Logical Functions (DAX)
DAX FunctionsHi there,
In this post, we will discuss about one of the types of DAX Functions. These functions basically supports the needs of Business Intelligence Analysis. These functions will help to manipulate data using time periods.
TYPES OF DAX:
- DATE AND TIME FUNCTIONS
- FILTER FUNCTIONS
- INFORMATION FUNCTIONS
- LOGICAL FUNCTIONS
- MATHEMATICAL AND TRIGNOMETRIC FUNCTIONS
- STATISTICAL FUNCTIONS
- TEXT FUNCTIONS
- TIME INTELLIGENCE FUNCTIONS
...
- AND: This function checks whether both arguments are TRUE which returns TRUE, else FALSE.
- FALSE: This function returns the logical value FALSE.
- IF: This function checks if a given condition is met, if condition is met, returns one value and if conditions is not met, returns different value.
- IFERROR: This function evaluates an expression and returns a specified value if the expression returns an error. Otherwise, returns the value of the expression itself.
- NOT: This function changes FALSE to TRUE or TRUE to FALSE.
- OR: This function checks whether one of the arguments is TRUE to return TRUE, else, FALSE
- SWITCH: This function evaluates an expression against a list of values and returns one of multiple possible result expressions.
- TRUE: This function returns the logical value TRUE.
There are 8 DAX Logical Functions available to manipulate the pivot data.
DID YOU USE DAX FUNCTIONS?
Please do share your views and thoughts about this posts in the below comments section.
If you like this post, please share it on your social networking sites by clicking on the icons placed around the blog.
To receive such updates to your inbox, REGISTER here for free.
SOME IMPORTANT LINKS:
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments