The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
@nirrobi Can you post some sample data of your tables?
So we can see how the tables are organized and how they are related?
Also do you have a Calendar table?
Sure,
Hope it will help.
I have one table for invoices (with duplicate), one table for sales (with duplicate).
and I create in power bi desktop append query with remove duplicate.
then I try to connect the sales ID with date of invoice and date of sale and got the attached error
thanks.
Regarding the error in the picture, the documentation online says
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.
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
i try but not find where I can uplod pbix file, can you help please.
many thanks.
You can upload an attachment when replying.
sorry.
I can't find it :-((((
only pic as attached
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.
check and work like a charm!!!
many thanks.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
82 | |
64 | |
58 |
User | Count |
---|---|
248 | |
123 | |
112 | |
79 | |
78 |