Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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
No file at that link.
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.
Hi,
Apologies the invoice number is called faktuurnr
When I try adding 2 faktuurnr/invoices into the table representing the debtors and creditors, I got this error.
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.
| User | Count |
|---|---|
| 51 | |
| 38 | |
| 33 | |
| 22 | |
| 19 |
| User | Count |
|---|---|
| 136 | |
| 102 | |
| 58 | |
| 36 | |
| 35 |