Splitting columns by Delimiter with DAX (No Query Editor)

You said right-most delimiter, but then put Geotext as the answer. that is the left-most.

For the right-most, to return Global, use this:

Column = 
TRIM (
    MID (
        SUBSTITUTE ( [Column1], ".", REPT ( " ", LEN ( [Column1] ) ) ),
        ( LEN ( [Column1] ) - LEN ( SUBSTITUTE ( [Column1], ".", "" ) ) )
            * LEN ( [Column1] ) + 1,
        LEN ( [Column1] )
    )
)

For the left most, use this:

Column 2 = 
    LEFT(
        [Column1],
        FIND(".",[Column1]) - 1
    )

I am curious about your issues with the Power Query editor. It is designed for data modeling. DAX is designed for analysis, not modeling. See issues below with extensive data modeling in DAX vs your source or Power Query. The tables in DAX are not like Excel spreadsheets. Can you share more about your issues with the PQ editor?

In general, try to avoid calculated columns. There are times to use them, but it is rare. Getting data out of the source system, creating columns in Power Query, or DAX Measures are usually preferred to calculated columns. See these references:
Calculated Columns vs Measures in DAX
Calculated Columns and Measures in DAX
Storage differences between calculated columns and calculated tables
Creating a Dynamic Date Table in Power Query