Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 id , date of arrival and date of invoice (afterward will create diffrence between those 2 dates) but get error from Power BI Desktop (seems like connection issue).
if I try to connect for example, sales id count of item and sum of invoice it work perfectly (exactly the same tables but diffrent colmn, hence I assume the connection is well configure)
Can anyone think of any solution.
Many thanks in advance.
Nir
Solved! Go to Solution.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |