Forum Discussion
Solved
Transforming Data - Filtering Rows to values that only start with a numerical digit
Hi, I'm currently at the stage of sorting out the data I want from our database in a dashboard and need to filter out certain rows in the model. Effectively, based on a field called 'Form or Set...
Hi RFJammer , hello sjoerdvn, Kedar_Pande and HotChilli, thank you for your prompt reply!
You could also add the filter row in power query advanced editor as shown below:
= Table.SelectRows(#"Changed Type", each Text.Start([Form or Set], 1) >= "0" and Text.Start([Form or Set], 1) <= "9")Result:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
= Table.SelectRows(#"Added Custom", each Value.Is(Number.FromText(Text.Start([Form or Set], 1)), type number))
This checks if the first character of the "Form or Set" column is a number, making the filtering much cleaner and easier to maintain.