Forum Discussion

Jelto83's avatar
Jelto83
Frequent Visitor
5 years ago
Solved

Pivot Data into Lists without Aggregation/Counting or Summing the data

Hi,   I'm sure that this is going to be an easy solution for someone out there, but it's had me in circles the last few days.   Requirement: Users require a dynamic dependent dropdown list where ...
Need Help
  • Jelto83's avatar
    Jelto83
    5 years ago

    I've found an iterim own solution to this. I had to add an INDEX Column before Pivoting the data with out Aggretating it and it worked. Now have to format the data around but in essence it has sort of worked.  Would still love a better solution in the longterm - I'm guessing some sort of incremental counter against each Supplier ID

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

i think the table.group function is for you. If you submit a sample table, we can try it

  • Jelto83's avatar
    Jelto83
    Frequent Visitor
    5 years ago

    No problem and thank you!

     

    What is the best way to submit a sample table (sorry also new to this site!) 😁

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    you should do somethink like this:

     

    let
.....
  your previuos steps
LastStep= somefunction(ofsomethonk)
.....
    #"Modificato tipo" = Table.TransformColumnTypes(LastStep,{{"sn", type text}, {"sku", type text}}),
    rr = Table.Group(#"Modificato tipo", {"sn"}, {{"skALL", each _[sku]}}),
    tfc=Table.FromColumns(rr[skALL],rr[sn])
in
tfc