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

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 
If I understood you,
Your table:

 

The measure:

 

Extraction = (IF(Len(MAX('Extract'[Values])) = 3, Max('Extract'[Values])))

 

The result:

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel