Forum Discussion
Active ProductPath for each customer
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Impressive work Zoe Zhi, I'm very pleased with your solution, thank you!
Last question, how can I change the following M-code to get unique ActiveProductPaths?
= Table.Group(#"Type gewijzigd", {"Aangepast", "Customer"}, {{"Path", each Text.Combine(List.Sort(Text.Split(Text.Combine([Product], ","), ","),Order.Ascending),", "), type text}})
On the 29th of July we have the productpaths "B" and "B, B". I want them to get only B, how can I change the formula?
https://www.dropbox.com/s/zvrxfymkw5x9tp7/Photo%20ActiveProductPath.png?dl=0
https://www.dropbox.com/s/opsqiam7fwmvzbw/ActiveProductPathv3.pbix?dl=0
Thanks in advance!
Regards,
Cor
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!!!!!! 🙂
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? 😉