Forum Discussion
Anonymous
5 years agoNot applicable
Need Help - Extracting Values from a Column then Filter on those Values
To Support Community: I have a column of data in a table that looks like this: 1 1.1 1.1.1 1.1.1.1 1.1.2 1.1.2.1 1.2 1.2.1 1.2.1.1 1.2.2 1.2.2.1 1.3 1.3.1 ...
- 5 years ago
Here is one way. This will make a list of the values meeting your criteria which you can then convert to a table to be used in a slicer. You could also use the same logic of List.Count(Text.Split([TextColumn, "."))=2 in a custom column with if..then.else to create a column to filter by in the next step. For this one, just right click last step and "Insert Step After" and use this M code, referencing your text column name.
= List.Select(#"Changed Type"[TextColumn], each List.Count(Text.Split(_, "."))=2)
Regards,
Pat
HotChilli
Community Champion
5 years agoCan't you test the length of the string to see if it equals 3?