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" )
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"
)Thank you for the help! That worked! :smileyhappy:
