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 UserAssuming this is the output you want :
You need to create a calculated column not a measure to achieve your result :
Thanks a lot for your feedback, Actually I need the data before the "." so I used left instead, but I get an error.
Is there something i'm doing wrong ?
- AmiraBedh
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.
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 :