cancel
Showing results for
Did you mean:

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

Helper V

## Filtering out

Hello,

Is there a way I can only keep values that have 10 digits?

For example I want to keep only the fields that have 10 digits?

2 ACCEPTED SOLUTIONS
Solution Specialist

Hi @amandabus21 ,

try this:

Table.SelectRows(PreviousStep, each Text.Length([Column1]) > 10 )

``````let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMDI0MLI0MDRQitWB8IHIHIVjYmpmhFuWDhwzAwNzCxjHwMAYwTTEKoqdaUgaMxYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Filtered Rows" = Table.SelectRows(Source, each Text.Length([Column1]) > 10 )
in
#"Filtered Rows"``````

Helper II

I like the solution provided above by: latimeria; however, instead of " > 10 ", I think you would want " = 10 ".

Good luck.

2 REPLIES 2
Helper II

I like the solution provided above by: latimeria; however, instead of " > 10 ", I think you would want " = 10 ".

Good luck.

Solution Specialist

Hi @amandabus21 ,

try this:

Table.SelectRows(PreviousStep, each Text.Length([Column1]) > 10 )

``````let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMDI0MLI0MDRQitWB8IHIHIVjYmpmhFuWDhwzAwNzCxjHwMAYwTTEKoqdaUgaMxYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Filtered Rows" = Table.SelectRows(Source, each Text.Length([Column1]) > 10 )
in
#"Filtered Rows"``````

Announcements

#### New forum boards available in Real-Time Intelligence.

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

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors