Forum Discussion
Format Data
Anonymous , I checked out left/right/len is dax allowed function for column and measure in direct query. I tested it in direct query mode
Column = right([column],LEN([column])-2)Tested in Sql Server direct query
Please refer the supported functions : https://docs.microsoft.com/en-us/analysis-services/tabular-models/dax-formula-compatibility-in-directquery-mode-ssas-2016?view=asallproducts-allversions
Hi Anonymous ,
You may go to Add column -> Custom column, create custom column like codes below.
= Table.AddColumn(Source, “Number”, each Text.Select([UDER ID], {“0”..”9″}))
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Where do you want to do the transformation, in Power Query or in DAX?
Will it always be DB followed by a number? (in that case you could replace DB with an empty string)
Will it always be two characters? in that case you can use substrings etc.
Hey lbendlin ,
Thanks for a quick response.
I want the change in the Power Query.
It will always be DB followed by a 8-digit number.
Yes, it will always be two characters.
Thanks,
Sona