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.
Microsoft EmployeeRegarding the error in the picture, the documentation online says
- You are trying to use two or more fields from tables that are not related. You need to remove the unrelated fields from the visual and then create a relationship between the tables. Once you have done this, you can add the fields back to the visual. This can be done in Power BI Desktop or Power Pivot for Excel. Learn more
Please try to follow the above recommendation.
By the way, how do you append query with remove dulicate? And why do you connect those tables via date columns? Based on my understanding, those tables are linked by the SALESID.
Helper V
thanks for your reply.
I read the documantation but no help. I think is not my case.
append query - yes with remove duplicate else it not working.
conncection is indeed sales ID to sales ID to sale id no date in the relation ship.
I try to make table of sales id -sales date - inv date
- Eric_Zhang
- nirrobi
i try but not find where I can uplod pbix file, can you help please.
many thanks.
- Eric_Zhang
You can upload an attachment when replying.