Split text in calculated column

[Anonymous]

Hi All, Need some urgent help , I need to split text in calculated column as below please note it is a claculated column so please do not suggest any power quesry tricks it wont work it has to do with right function but not sure:

21/01/2022 Resource

01/04/2021 Planning

14/04/2021 Implementation

Final result to look like :

Resource

Planning

Implementation

Thanks

[Anonymous]

Thank you So Much

[amitchandak]

@Anonymous , Try a new column in DAX like

Right([COlumn], len([Column]) - search(" ", [Column],,0))

[Anonymous]

Hi Amit it is throwing error search has the wrong data type or invalid value

[amitchandak · Accepted solution]

@Anonymous , Check this

Column = RIGHT([Column1],LEN([Column1]) -SEARCH(" ",[Column1],,0))