Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous , Check this
Column = RIGHT([Column1],LEN([Column1]) -SEARCH(" ",[Column1],,0))
Thank you So Much
@Anonymous , Try a new column in DAX like
Right([COlumn], len([Column]) - search(" ", [Column],,0))
Hi Amit it is throwing error search has the wrong data type or invalid value
@Anonymous , Check this
Column = RIGHT([Column1],LEN([Column1]) -SEARCH(" ",[Column1],,0))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |