Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

Problem Linking 2 Factual Sheet

Hi,

 

I'm creating a table wherein every project will show its own corresponding debtor and creditors with their respective invoices.

 

I create a bridge but when i entered the invoices i had this error. Can anyone help me solve this problem? I uploaded the file using the link provided.

 

//NT

 

https://file.io/mixmx0p6kpFE

 

tksnota_0-1721009107342.png

 

5 REPLIES 5
Ashish_Mathur
Super User
Super User

No file at that link.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Hi,

 

Please try this link...

 

//NT

 

https://file.io/Pvz3tYmmEdGq

Hi,

I do nto see any error when i open the file.  Furthermore, i do not see any invoice column in any of the tables.  Not sure of what you want but i think you should create another table with all uique invoices and create a Many to One relationship (from Debtors and creditors) to this new invoices table.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Hi,

 

Apologies the invoice number is called faktuurnr

 

tksnota_2-1721116931948.png

When I try adding 2 faktuurnr/invoices into the table representing the debtors and creditors, I got this error.

 

tksnota_0-1721116814036.png

 

I uploaded the file again using this new link - https://file.io/wdlFPrDG3DPP

 

//NT

Please implement the second sentence of my previous message.  To the visual, drag invoice number from the newly created table.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.