Power BI DAX LEN function returns the length of a given string. Its comes under Text DAX functions category.
Syntax:
LEN(string)
Description:
| S no. | Parameter | Description |
| 1 | Text | The text whose length you want to find. Spaces count as characters. |
Let’s start with an example:
Step-1: Sample Dataset as below:
Sample Dataset for DAX String Functions
Step-2: Create New column, right click on Dataset & click on New column.
Step-3: Now we finds the length of a character string in the Product Sub Category name column, write below DAX for this.
Len_Dax = LEN(Orders[Product Sub-Category])
Step-4: Drag new column in Table visual, then right click on new column under values section and click on Don’t summarize.
Len Example
Step-5: Output as below
LEN Function Example
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.
Recommended DAX Post: