Forum Discussion
Automatically Split One Table into Smaller Tables based on a row value (Name)
Hello, I am working with a dataset with 15mm+ rows, so needless to say I am running into issues while writing some formulas. I have found if I make the data set smaller the formulas work. S...
Hey Pat,
Below is the formula, currently it's just on the table, I was wondering if I did it at the query level that would help. If it helps when I limit the table to about 16-20k rows the formula works no problem.
Data set is about 15mm rows and 26 columns.
Previous Action = CALCULATE(MAX('Test'[Date]),
(Filter('Test',EARLIER('Test'[ID])='Test'[ID] &&
EARLIER('Test'[Date])>'Test'[Date])
Do you know of a way to write that formula to make a custom column in the query?