I have a fairly large table in Excel which is linked to my Power Pivot as data source.
I have the following function in the Excel Table:
=SUMPRODUCT(--(fdataTable1[Passenger phone number]=[@[Passenger phone number]]),--(fdataTable1[Completed Time]<[@[Completed Time]]))
This function is making my Excel sheet run slow, therefore I was looking for a way to get rid of this column in the source excel file and instead create the same in Power Pivot as a Calculated Column.
Some help would be appreciated.
Bookmarks