Forum Discussion

FBerdial's avatar
FBerdial
Frequent Visitor
2 years ago

Expand excel column

Hi, 

I´m new in power Bi and need help.

I have an excel column tabulated as shown in color column.

How can transform it in one or three colums as shown?. I have to iterate de table but i don´t now how to recover values from previous files or store values in parameter who can change.

Please help!

Need Help

2 Replies

  • dufoq3's avatar
    dufoq3
    Community Champion
    2 years ago

    Hi FBerdial, I can try but could you provide sample data? I don't know how to simulate your [Sección] column

    • FBerdial's avatar
      FBerdial
      Frequent Visitor
      2 years ago

      Hi dufoq3,

       

      I'do with this sentences 

      #"Columna condicional agregada" = Table.AddColumn(#"Filas filtradas", "Seccion", each if [Longitud] = 2 then [Sección] else null),
      Relleno = Table.FillDown(#"Columna condicional agregada", {"Seccion"}),
      #"Columna condicional agregada1" = Table.AddColumn(Relleno, "Programa", each if [Longitud] = 4 then [Sección] else null),
      Relleno1 = Table.FillDown(#"Columna condicional agregada1",{"Programa"}),
      #"Columna condicional agregada2" = Table.AddColumn(Relleno1, "Subconcepto", each if [Longitud] = 6 then [Sección] else "000000"),
      #"Personalizada agregada" = Table.AddColumn(#"Columna condicional agregada2", "Indice", each [Seccion]&[Programa]&[Subconcepto])

       

      Thanks for your help