« Statistical Functions (DAX) | Time Intelligence Functions (DAX) » |
TEXT FUNCTIONS (DAX)
powerpivot, 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
...
- BLANK: This function returns blank cells, here blank cells are not basically null.
- CONCATENATE: This function joins two text strings into one.
- EXACT: This function compares two text strings and returns TRUE, if exact match, else FALSE. This function is a case-sensitive but ignores formatting differences.
- FIND: This function returns the starting position of the one text string within another. This function is a case-sensitive.
- FIXED: This function rounds a number to the specified number of decimals and returns the text result. We can specify the result format with commas or without commas.
- FORMAT: This function converts a value to text based on the input format.
- LEFT: This function returns a specified number of characters from the start of a text string.
- LEN: This function returns the number of characters in a specified cell.
- LOWER: This function converts all letters in a text string to lowercase.
- MID: This function returns a string of characters from the middle of a text string, for given starting position and length.
- REPLACE: This function replaces part of a text string, based on the number of characters specified, with a different text string.
- REPT: This function repeats text, the number of times mentioned,.
- RIGHT: This function returns the last character(s) in a text string, based on the number specified,.
- SEARCH: This function retunrs the number of character at which a specific character is first found, reading left to right. This is a case insensitive.
- SUBSTITUTE: This function replaces the existing text with new text.
- TRIM: This function removes all spaces from text except for single spaces between the words.
- UPPER: This function converts a text string to all uppercase letters.
- VALUE: This function converts a text string that represents a number to a number.
There are 18 DAX Text 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