Forum Discussion

fav_ccc2021's avatar
fav_ccc2021
Icon for Helper I rankHelper I
2 years ago
Solved

Invertir numero con DAX

Hola a todos

 

me pueden ayudar a invertir un numero con dax?

Ejemplo:

 

15254956  ---->  65945251

 

Desde ya muchas gracias por la ayuda!!!

  • lbendlin's avatar
    lbendlin
    2 years ago

    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.

     

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      for the record here is a more concise version

       

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