Forum Discussion
Shorting an Alphanumeric column
I have a column in my data base and data type of the column is varchar. Column data are like: 1 year 3 days 11 hours 2 months I want to short the data like below: 11 hours 3 days 2 MONTHS...
Hi Anonymous ,
Not certain what is your expected output based on your picrture and description. Could you please consider sharing some sample data and expected output for further discussion?
Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.