Forum Discussion
Anonymous
3 years agoNot applicable
Filter rows based on length in Power Query
Hello all! I am working with a table that has phone numbers of varying lengths in a column called dialednumber as part of the table ytd_cb. What I want is a query that will filter the table ...
m_dekorte
3 years agoResident Rockstar
Hi Anonymous,
Give this a go. Set a manual filter on that column in your table, this is just to create the bulk of the syntax.
Next inside the formula bar update the code as highlighted here:
Please mark this answer as solution when it helped you to resolve your question, thanks!