Forum Discussion
nirrobi
Helper V
Helper VCan not create visual (table) from 2 related table that connect properly (I think)
Hi all, I face strange situation, I have table for invoices and table for arrival date (both have date column as it not the same date), I want to create visual (table) that shows the sales i...
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.
nirrobiHelper V
Helper Vsorry.
I can't find it :-((((
only pic as attached
KumarDarmesh
Helper IV
Helper IV
Eric_ZhangMicrosoft Employee
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
- nirrobi
- nirrobi
check and work like a charm!!!
many thanks.