Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
macemit
Frequent Visitor

Text Length filter

‎09-17-2018 02:54 PM

Hi,

 

Trying to create what should be an easy filter based on length of a text entry (I need to keep those with 13 characters):

 

#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each Text.Length([Serial_Number__c] = 13))

Can someone help?

 

Thanks.

Labels:
Message 1 of 2
17,561 Views
0
1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

‎09-17-2018 03:51 PM

Move the bracket.

Text.Length([Serial_Number__c]) =

View solution in original post

Message 2 of 2
17,569 Views
1 REPLY 1
HotChilli
Super User
Super User

‎09-17-2018 03:51 PM

Move the bracket.

Text.Length([Serial_Number__c]) =
Message 2 of 2
17,570 Views

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All