Forum Discussion
How can I correct this error?
I have this error that has started
Column 'Money to / From…?' in Table 'ADF2' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
From this data, I am pretty sure it is in relation to rows 8 & 9 but this data is unique.
FE | Matter No | Clients Name | Money to / From…? | Description of Monies Received | Expected In £ | To Send Out £ | Date Expected |
MAJ004-0001 | Maj | Santander | advance | £73,415.00 | 23-Feb-17 | ||
MAJ 004 0001 | MAJ | Direction Law | purchase | £91,500.00 | 24-Feb-17 | ||
MEE015-0003 | Meek | MR& MRS MEEK | CGT a/c payment | £127,552.60 | 20-Feb-17 | ||
CRA112-0001 | Craig | client | bal due | £379,234.80 | |||
CRA112-0001 | Craig | Thackray Williams | purchase | £369,139.80 | 24-Feb-17 | ||
WAK016-0001 | Wakeford & Waghorn | client | bal due | £73.15 | |||
WAK016-0001 | Wakeford & Waghorn | Santander | advance | £108,765.00 | 22-Feb-17 | ||
WAK016-0001 | Wakeford & Waghorn | Help to buy ISA | HTB Isa | £900.31 | |||
WAK016-0001 | Wakeford & Waghorn | Help to buy ISA | HTB Isa | £925.10 | |||
WAK016-0001 | Wakeford & Waghorn | Sharratts | staircasing and apportionments | £37,278.56 | 23-Feb-17 | ||
WAK016-0001 | Wakeford & Waghorn | Anthony Stockton | purchase | £91,250.00 | 23-Feb-17 | ||
COO205-0002 | Cooley | O'Neill patient | sale | £229,500.00 | 23-Feb-17 | ||
COO205-0001 | Cooley | Nationwide | advance | £125,000.00 | 22-Feb-17 | ||
COO205-0001 | Cooley | Keystone Law | purchase | £378,000.00 | 23-Feb-17 | ||
COO205-0001 | Cooley | client | bal due | £14,541.00 |
Is there any way to stop this error?
1 Reply
Hi krisso,
Which error did you get? To create a Many-to- one relationship, at least one column in one of the tables must contain unique values. For more information, see: Create and manage relationships in Power BI Desktop.
Best Regards,
Qiuyun Yu
