Remove text dynamically

[jk-vtti]

Hello. Is there a way to remove text dynamically, such as all text up to and including a period (eg. changing hello.people to people). I have values whose first part differs in length (eg. goodbye.people to people), and need to remove the first part each time, preferably with DAX. Thanks! Joel.

 

[MD610]

If the "divider" is always a period, then this should work as a Calculated Column:

=RIGHT([ColumnWithText], LEN([ColumnWithText])-FIND(".",[ColumnWithText]))

 

[jk-vtti]

Thank you - works great.