DAX: PowerBI great to see what you do. And what you don't do? Customers that buy and don't buy

[lprbi]

Hi,

I see that PowerBI it's great to smash your data, but if you need informations that not comply relationships, for example:

I need show all customers that buy and not buy, related to a orders table and categorize them by period.

I solved importing several times the same data, with different relationships but this is the right way? Tried Crosstab function too, with no luck...

Relationship per page?

Thanks in Advance

[itchyeyeballs]

 Any use? - http://www.daxpatterns.com/basket-analysis/

[lprbi]

Yes, but in my case I suppose that will need use CROSSFILTER (to disabe the current relationship with orders and customers).

But in my last case CROSSFILTER no freed the records of the table. Only importing a free of relationships table I could bring the correct values.

I need a list like this:
DATE                     |  CUSTOMES     |  BUYED
----------------------------------------------------------------

OCTOBER 2015    |  CUSTOMER 1 | NO

OCTOBER 2015    |  CUSTOMER 2 | NO

OCTOBER 2015    |  CUSTOMER 3 | YES

DECEMBER 2015  |  CUSTOMER 1 | YES

DECEMBER 2015  |  CUSTOMER 2 | NO

DECEMBER 2015  |  CUSTOMER 3 | YES