Need help with a data model relationship

[rmcgrath]

I am pulling in a table that has unique account numbers.  And then I am also pulling in PDF electricity invoices.  The invoices have meter numbers.  The issue I am having is (1) meter number might be assigned to multiple account numbers.  How do I handle this in the data model?

ConcatAccountMeterNumberPercentageSort

70-034-6800-100	KZD86614917	0.36	2
70-062-6800-601	KZD86614914	0.5	5
70-062-6800-602	KZD86614914	0.5	6
70-070-6800-100	KZD86614917	0.28	3
70-010-6800-100	KZD86614917	0.36	1
70-062-6800-603	KZD96632767	1	7
70-030-6800-100	1ND78105667	1	4

Sample of the table from the invoices:

April 2024 Services.pdf	Meter#	Dates_From	Dates_To	Reads_From	Reads_To	Usage	Multiplier	Used	Units	Estimate	Used_NEW	Percentage	Used_FINAL
April 2024 Services.pdf	KZD86614917	4/2/2024	5/2/2024	1780.562	1851.644	71.081	2100	149,270.940	KVR	No	149270.1	0.36	53737.236
April 2024 Services.pdf	KZD86614917	4/2/2024	5/2/2024	1780.562	1851.644	71.081	2100	149,270.940	KVR	No	149270.1	0.28	41795.628
Aug services2024.pdf	1ND78105667	8/2/2024	9/3/2024	140379.42	141623.118	1243.698	1	1,243.699	KWH	No	1243.698	1	1243.698
May Services 2024.pdf	1ND78105667	5/2/2024	6/4/2024	137288.869	138229.049	940.18	1	940.185	KWH	No	940.18	1	940.18
Oct 2024 Services.pdf	KZD96632767	10/20/2024	10/20/2024	null	79.36	null	1	79.360	KW	No	79.36	1	79.36
Sept Services 2024.pdf	KZD96632767	9/3/2024	10/2/2024	1948.45	2075.936	127.485	200	25,497.100	KWH	No	25497	1	25497

[Greg_Deckler · Accepted solution]

@rmcgrath Power BI supports many-to-many relationships or you could use a bridge table with distinct meter #'s.

[rmcgrath]

A bridge table!  I did not think of that...thank you!!