Invertir numero con DAX

[fav_ccc2021]

Hola a todos

me pueden ayudar a invertir un numero con dax?

Ejemplo:

15254956  ---->  65945251

Desde ya muchas gracias por la ayuda!!!

[lbendlin · Accepted solution]

Column2 = 
var a = Format([Column1],"#")
var b = SELECTCOLUMNS(GENERATESERIES(1,len(a)),"Index",[Value])
var c = GENERATE(b,{mid(a,[Index],1)})
return CONCATENATEX(c,[Value],"",[Index],DESC)

NOTE: This will fail (sort of)  if the last digit of the number is 0.

[lbendlin]

for the record here is a more concise version

= CONCATENATEX(ADDCOLUMNS(GENERATESERIES(1, LEN([Number])), "Rev", MID([Number],[Value],1)), [Rev], "",[Value],DESC)