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.