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 col umn 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...
Need Help
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