Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
matthierry
New Member

How to create a new field taking a variable and filtering it

matthierry_0-1677249614039.png

 

I woul like to create a new value using the field GOO_MAJOR_REFERENCE but filtering it, I just need the data that are located before the "." of the reference. 

How is that possible ? 

Thanks

 

1 ACCEPTED SOLUTION

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.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

View solution in original post

5 REPLIES 5
AmiraBedh
Resident Rockstar
Resident Rockstar

Assuming this is the output you want : 

AmiraBedh_0-1677250367925.png

You need to create a calculated column not a measure to achieve your result : 

NewReference = RIGHT('MyTable'[GOO_MAJOR_REFERENCE], FIND(".", 'MyTable'[GOO_MAJOR_REFERENCE])-1)

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

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 ? 

 

matthierry_0-1677747423452.png

 

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.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Sorry, the ")" was a mistake. I typed the right formula but still get an error ... 

 

matthierry_0-1677826478434.png

 

Is there something in the type of data (text, data, ... ) that i need to change ? 

I reproduced the same thing : 

AmiraBedh_0-1677856017960.png

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.