Hello,
I have a large dataset and I need to calculate the sum total for each day (which contains 23-24 data points). The dates/addresses repeat for different programs. I am having trouble creating a new measure via the pivot table or using a DAX formula in Power Pivot. Using excel formulas causes excel to freeze as it's checking millions of cells. Attached is a sample with the sum total for the day (it does not have to repeat as seen in the sheet). Thanks.
Bookmarks