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/1jfqupyrfdwks3t/Dummy-file%20ActiveProductPath.xlsx?dl=0 

 

For example customer 1 have bought 4 products in 2019. 

On 01-04-2019 was only product A active, on 01-07-2019 also product A, on 01-10-2019 the products B and C were active and on 01-01-2020 is product D active.

 

The endresult on 01-04-2019 should be:

CustomerActiveProductPath
1A
2E
3H,I
4 

 

Can someone help me?

 

Thanks in advance!

 

Greetings from The Netherlands,


Cor

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.

     

9 Replies

  • dax's avatar
    dax
    Community Support
    6 years ago

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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!