Forum Discussion
Solved
LEN Function Not Working with Subtraction
Email = RIGHT(RE_Usage_Data[User],LEN(RE_Usage_Data[User])-3)&"@xyz.com" Hello! When I entered the function above into the Data view in Power BI, I receive an error stating "An Argument of funct...
The issue is you have a value with 3 or less characters somewhere in your list. Try this formula instead.
Email = Var Length = LEN(RE_Usage_Data[User]) RETURN IF( Length <= 3, "", right([Name], Length - 3) & "@xyz.com" )
As a measure:
Measure 7 = RIGHT(MAX(Email[Column1]),LEN(MAX(Email[Column1]))-3)&"@xyz.com"