Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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?
Solved! Go to Solution.
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"
I like the solution provided above by: latimeria; however, instead of " > 10 ", I think you would want " = 10 ".
Good luck.
I like the solution provided above by: latimeria; however, instead of " > 10 ", I think you would want " = 10 ".
Good luck.
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"
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
9 |