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" )
I don't know, that worked for me as a column, are you trying to do this aas a measure?