Forum Discussion

Bertverderrie's avatar
Bertverderrie
Frequent Visitor
5 years ago

Product combination per customer

Hi guys   I'm struggling here, any help is welcome! I'm looking to generate a calculated column for each costumer in tabel Dim_Klant that tells me which products are in his contract at the end of ...
Need Help
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Bertverderrie ,

 

I don't really see why you want to do a measure or calculated column.

You can solve that with slicers and a matrix.

 

You can filter for the date, product family and see which customer has which amount of specific products at the given time:

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

 

Bertverderrie's avatar
Bertverderrie
Frequent Visitor
5 years ago

Hi selimovd ,

Maybe I can show you why,
I've added the desired column to the sample excel..
I want to track the amount of clients that were under contract with a certain combination of products at any time. In order to get a visual looking something like this

Sample file here 

 


(im aware this visual shows only the number of products, not unique customers but you get the idea)

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Bertverderrie  "sorry, this download link no longer exists :("