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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
amandabus21
Helper V
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?

 

amandabus21_0-1679337303029.png

 

2 ACCEPTED SOLUTIONS
latimeria
Solution Specialist
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"

 

View solution in original post

ND_Pard
Helper II
Helper II

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

Good luck.

View solution in original post

2 REPLIES 2
ND_Pard
Helper II
Helper II

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

Good luck.

latimeria
Solution Specialist
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"

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors