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 think the Month in column should be continuous, you could refer to my sample for details.
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.
Excellent solution Zoe Zhi, thank you very much!!
Last part of the challenge:
For every customer I want for each ref Ref_Date’[FullDate] the ActiveProductPath in a table in Power Query so I can use a slicer and count the customers who had a certain ActiveProductPath.
In the end I want an answer for the question: “how many customers have ActiveProductPath “x” on a certain day?”
Can you help me with the last part of the solution?Thanks in advance!
I've made another dummyfile, https://www.dropbox.com/s/cjkjr4b5184v2y6/Dummy-file%20ActiveProductPathv2.xlsx?dl=0
and https://www.dropbox.com/s/1828euve4n17gry/ActiveProductPathv2.pbix?dl=0
Hopefully you will understand what I mean.
I want to count each ActiveProductsPath for each date.
The result should be:
Date A B C A, B1-4-2019 2 1 1-7-2019 1 1 1 1-10-2019 2 1-1-2020 1 2 Can someone help me?
Hi corvada,
According to your description, it seems that you want to show the "A, B" in column , right? As I know, you need to use field instead of measure in column of Matrix. You might need to change the data structure. I am still working on this and will inform you as soon as I get it.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.