Forum Discussion

spider_Monkey's avatar
spider_Monkey
Icon for Helper I rankHelper I
3 years ago

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...
General Comment
spider_Monkey's avatar
spider_Monkey
Icon for Helper I rankHelper I
3 years ago

Do you know of a way to write that formula to make a custom column in the query?

ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

Please try this column expression instead.

Previous Action =
VAR thisdate = 'Test'[Date]
RETURN
    CALCULATE (
        MAX ( 'Test'[Date] ),
        ALLEXCEPT ( 'Test', 'Test'[ID] ),
        'Test'[Date] < thisdate
    )

 

Pat

  • spider_Monkey's avatar
    spider_Monkey
    Icon for Helper I rankHelper I
    3 years ago

    Morning ppm1 ,

     

    No luck it tells me not enough memory to complete the operation. I tried a version of that formula first and got the same error. 

     

    Is there anyway to write this in Mquery?