Power BI DAX LEN function returns the length of a given string. Its comes under Text DAX functions category.
|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:
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.
Step-5: Output as below
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: