Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Active ProductPath for each customer

Hey all,   I need some help with an "ActiveProductPath", hopefully someone can help me.    I want for each customer the path of the active products, see attachment,   https://www.dropbox.com/s/1...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi corvada,

    I change something in the data model based on your requirement , you could refer to my sample to see whether it work or not.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I already know the answer:  Table.Group(#"Type gewijzigd", {"Aangepast", "Customer"}, {{"Path", each Text.Combine(List.Sort(Text.Split(Text.Combine(List.Distinct([Product]), ","), ","),Order.Ascending),", "), type text}})

 

Thanks Zoe Zhi!!!!!! 🙂 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Question, the dummy files contains 15 rows, the table with the solution contains more than 900 rows... What if I would use the solution for 7 million products? Is it possible to make a solution with virtual tables instead of physical tables? If so, how? 😉