Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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