Forum Discussion
Helper VCan not create visual (table) from 2 related table that connect properly (I think)
Based on my test, the problem is caused by the relationship among tables. If the relationship is 1:1,1:1 among the three tables, the original table visual in your pbix would work.
In your case(many:1,many:1), use two measures instead.MAX INV DATE = MAX(INVOICES[INV DATE]) MIN SALES DATE = MIN(SALES[SALES DATE])
If you have any question, feel free to let me know.
Helper Vi try but not find where I can uplod pbix file, can you help please.
many thanks.
Microsoft EmployeeYou can upload an attachment when replying.
- Eric_Zhang
Based on my test, the problem is caused by the relationship among tables. If the relationship is 1:1,1:1 among the three tables, the original table visual in your pbix would work.
In your case(many:1,many:1), use two measures instead.MAX INV DATE = MAX(INVOICES[INV DATE]) MIN SALES DATE = MIN(SALES[SALES DATE])
If you have any question, feel free to let me know. - nirrobi
sorry.
I can't find it :-((((
only pic as attached
KumarDarmeshHelper IV
- nirrobi
- nirrobi
- nirrobi
check and work like a charm!!!
many thanks.