Forum Discussion
How to create a new field taking a variable and filtering it
When you said the data before "." you didn't precise if it is to the LEFT or to the RIGHT.
You can use the following syntax to create your calculated column :
NewReference = LEFT('MyTable'[GOO_MAJOR_REFERENCE], FIND(".", 'MyTable'[GOO_MAJOR_REFERENCE])-1)
The error you are getting is related to an extra ) at the end.
Super UserWhen you said the data before "." you didn't precise if it is to the LEFT or to the RIGHT.
You can use the following syntax to create your calculated column :
NewReference = LEFT('MyTable'[GOO_MAJOR_REFERENCE], FIND(".", 'MyTable'[GOO_MAJOR_REFERENCE])-1)
The error you are getting is related to an extra ) at the end.
Sorry, the ")" was a mistake. I typed the right formula but still get an error ...
Is there something in the type of data (text, data, ... ) that i need to change ?
- AmiraBedh
I reproduced the same thing :