Forum Discussion
Solved
Need help with a data model relationship
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
|
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 |
rmcgrath Power BI supports many-to-many relationships or you could use a bridge table with distinct meter #'s.
2 Replies
rmcgrath Power BI supports many-to-many relationships or you could use a bridge table with distinct meter #'s.
A bridge table! I did not think of that...thank you!!
