topic Re: Split text in calculated column in DAX Commands and Tips

Split text in calculated column

Anonymous — Fri, 28 Jan 2022 13:20:33 GMT

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

Re: Split text in calculated column

amitchandak — Fri, 28 Jan 2022 13:34:01 GMT

Anonymous , Try a new column in DAX like

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

Re: Split text in calculated column

Anonymous — Fri, 28 Jan 2022 13:43:30 GMT

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

Re: Split text in calculated column

amitchandak — Fri, 28 Jan 2022 13:56:01 GMT

Anonymous , Check this

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

Re: Split text in calculated column

Anonymous — Fri, 28 Jan 2022 15:05:48 GMT

Thank you So Much