Forum Discussion
Solved
Invoice/Invoice Details
Hi, I have a large table (30 columns) and 1 billion+ rows that has the invoice details at the invoice level (i.e. customer name, invoice number, date, etc.) and the invoice detail (line item cost...
Which articles have you read already? It does require duplicating the data, but puts less load on the relationship. See this explanation: https://www.sqlbi.com/articles/costs-of-relationships-in-dax/
If your invoice table is very large, it can be better to denormalize it.
Which articles have you read already? It does require duplicating the data, but puts less load on the relationship. See this explanation: https://www.sqlbi.com/articles/costs-of-relationships-in-dax/
If your invoice table is very large, it can be better to denormalize it.
AllisonKennedy Thanks! That was the one I was looking as well. I got concered with the size of the table, but seems like the relationship is more important. Thanks!