Forum Discussion
Split text in calculated column
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 , Check this
Column = RIGHT([Column1],LEN([Column1]) -SEARCH(" ",[Column1],,0))
4 Replies
Anonymous , Try a new column in DAX like
Right([COlumn], len([Column]) - search(" ", [Column],,0))
Anonymous , Check this
Column = RIGHT([Column1],LEN([Column1]) -SEARCH(" ",[Column1],,0))