Hello,
i have 2 Dataverse Tables, both are SQL Exports,
one is the Projects table (which has several additional custom columns i need for working),
the second one is a Export with all Invoices(one project can have many Invoices), both tables have the Project Number in it.
I would like to have the summary of all invoices per Project in the Project table.
i have tried different things but could not achieve it so far,
to work with a RollUp i need a link/relationship between all the rows --> a LookUp, am i right in this case?
I wont manually create a LookUp between 150.000 rows of invoices, is there no posibility to use the fact, that i have the project number as unique identifier in both of the tables?
thanks in advance
Thomas