Extract data from a column if the string matches multiple criterion

rb160488 ,

Personally, I would spend some time to try to cleanse the data at source to make it easier to work with.

A bit of a challenge but I believe I have a solution for you.  Needed to use a combination of the various TEXT functions available in DAX.

My first step was to find the start digit if your [Data Column] contains "FM":

FIND FM = FIND( "FM",FM[Data Column ], 1, 0 )

Next, I used the SWITCH Statement to create your 3 conditions given above:

Output1 = SWITCH( 
              TRUE(), 
              CONTAINSSTRING( [Data Column ], "FM-" ), 
                               MID( [Data Column ], [FIND FM], 6 ), 
                               // Satisfies the FM- scenario, but assumes only 3 digits after.
               CONTAINSSTRING( [Data Column ], "FM" ) && 
                 MID( [Data Column ], [FIND FM]+2,1) IN {"1", "2", "3","4","5","6","7","8","9"}, MID([Data Column ], [FIND FM], 5 ), 
                              // Satisfies "FM" & assumes 3 digits after 
               CONTAINSSTRING( [Data Column ], "FM ") && 
                 MID( [Data Column ], [FIND FM]+3,1) IN {"1", "2", "3","4","5","6","7","8","9"}, MID([Data Column ], [FIND FM], 6 ))

Output1

The only condition I wasn’t able to satisfy is if there are multiple FM’s in the same record.  I would need to give this one some extra thought.  There are probably alternative ways to play with the various text functions, but given all of the scenarios you provided, this was my best shot.  Hope you can make any adjustments necessary with your real world data.

https://learn.microsoft.com/en-us/dax/containsstring-function-dax

Regards,