Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Overlap table

Hello,   I'm relatively new at using Power BI, so I hope someone can help me with this question.   I want to make a overlap table of certain products on zip code level.   Example: I want to ma...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Than you for your help! However this is just a subset. Doing this for the whole dataset would take quite a lot of time, because there are many combinations possible. 

     

    In another topic I found this:

    https://community.powerbi.com/t5/Desktop/Sum-customers-by-product-combination-buyed-a-b-a-c-b-c-or-a-b-c/td-p/89362

     

    This did not bring me to the exact table I wanted, so I did the rest by hand. However this took quite a lot of hand work, because all all possible orderings of products appeared in different cells (a,b,c - a,c,b - b,a,c - etc.).

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous , As I have in mind, you can not put the same field in columns and rows in a matrix.

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for your reply!

 

There isn't another option in for example the query editor or by using a measure or something to get this done? Is it better to use another program, for example excel to do this? I also tried to do it in excel, but I don't know how to do it in excel either.