DAX for Split column by delimitor at the right most

[RENJITH_R_S]

Hello Friends, can you help me on this issue
Sub Category returns the text after the last delimitor and Main Category returns the text before the last delimitor
Please provide the dax formulas for Main Category and Sub Category. See the scrren shot

[bhanu_gautam]

@RENJITH_R_S , For Main Category

Main Category =
VAR CategoryText = [Category]
VAR LastDelimiterPosition = LEN(CategoryText) - FIND("~", SUBSTITUTE(CategoryText, "-", "~", LEN(CategoryText) - LEN(SUBSTITUTE(CategoryText, "-", ""))), 1)
RETURN LEFT(CategoryText, LastDelimiterPosition - 1)

Sub Category

Sub Category =
VAR CategoryText = [Category]
VAR LastDelimiterPosition = LEN(CategoryText) - FIND("~", SUBSTITUTE(CategoryText, "-", "~", LEN(CategoryText) - LEN(SUBSTITUTE(CategoryText, "-", ""))), 1)
RETURN RIGHT(CategoryText, LEN(CategoryText) - LastDelimiterPosition)

[RENJITH_R_S · Accepted solution]

@bhanu_gautam Thanks for the input, but not works.

I modified the formula as

MainCategory =

VAR CategoryText = 'Table'[Category]

VAR LastDelimiterPosition = LEN(CategoryText) - FIND("~", SUBSTITUTE(CategoryText, "-", "~", LEN(CategoryText) - LEN(SUBSTITUTE(CategoryText, "-", ""))), 1)

RETURN Left(CategoryText, LEN(CategoryText) - LastDelimiterPosition-1)

SubCategory =

VAR CategoryText = 'Table'[Category]

VAR LastDelimiterPosition = LEN(CategoryText) - FIND("~", SUBSTITUTE(CategoryText, "-", "~", LEN(CategoryText) - LEN(SUBSTITUTE(CategoryText, "-", "")))) + 1

RETURN Right(CategoryText, LastDelimiterPosition - 1)