Forum Discussion
azaterol
1 year agoHelper V
Aggregate distinct customers
Hello everyone, I have a matrix. I have two tables. A customer table and an invoice table. These are each connected bidirectionally with the customer number. I have the formula: purchasing P...
azaterol
1 year agoHelper V
lbendlin
1 year agoSuper User
Here's a different view of your data model. That Documentation table looks weird. What's the story behind it?
What is the first buy column intended to achieve? There is also a data quality issue for Documentation Nr. 4996 - conflicting customer IDs.
Bidirectional = bad. This here is Power BI, not Qlik. Power BI wants Star schemas.