The Power BI LEN function is one of the DAX text or string functions useful to return the length or total number of characters in a given string. This article explains the DAX LEN function that accepts the text to find the length and the syntax is as shown below:
LEN(<text>)
Power BI DAX LEN function Example
To demonstrate the DAX LEN() function, click the New Power BI calculated Column button in the Modeling Tab, and name as the ProductLength. The below expression finds the total number of characters in an English Product Name column for each row and returns the length.
Please add the ProductLength column to the table report. Next, click the down arrow to change from the default aggregate value Sum to the Don’t Summarize option. Please refer to the Power BI Charts article for the remaining graphs.
ProductLength = LEN(DimProduct[EnglishProductName])
Similarly, we have created one more column to find the length of the product description. Please refer to the DAX String functions and the DAX functions article available on the Power BI tutorial page for the remaining built-in functions.
DescriptionLength = LEN(DimProduct[EnglishDescription])
