Feb 07 2021 10:38 PM
Feb 08 2021 12:20 AM
As @Riny_van_Eekelen mentioned you need Power Query, but also likely Power Pivot
Id suggest you use Power Query to load the 2 tables of data into Power Pivot ( " The Data Model" ) and then create a relationship between them in the Diagram view (there needs to be a common field in both data sets for this to work, and ideally one table has a unique item in each row of that common field.
You can then load your results into a Pivot Table
Feb 08 2021 03:39 AM
Feb 08 2021 03:42 AM
Feb 08 2021 03:52 AM
Are you adding a column to the million row + table?
Where is your data being pulled from?
Ideally you want to be using 64 Bit Excel and have at least 8GB of RAM
If the problem continues you could load the data to the data model and add a calculated column there.
Feb 08 2021 05:42 AM
Perhaps I missed something, I understood initial tasks as filter one table based on values in another table column. Or okay, take values only from one or few columns of the first table, doesn't matter.
If so, why do you need any formulas and even relationships? Perhaps you may forget for a while about the size of the source and provide small sample which illustrates what shall be done.
So far I see that as DAX expression
evaluate FILTER(Table1, Table1[A] IN VALUES (Table2[A]) )