Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
  • mahoneypat's avatar
    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