Forum Discussion

Esmee's avatar
Esmee
Frequent Visitor
8 years ago
Solved

Earlier function with large dataset

Hi!   I have a large dataset about 3M records which looks like this:    campaignID persoon date amount number 1 a 3-6-2016 1 0 1 b 3-6-2016 1 1 1 c 3-6-2016 1 0 2 ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Esmee,

     

    Please remove 'person' filed and try to use below formula:

    measure =
CALCULATE (
    SUM ( Blad1[amount] );
    FILTER (
        ALL ( Blad1 );
        Blad1[date] < MAX ( Blad1[date] )
            && Blad1[persoon] IN VALUES ( Blad1[persoon] )
    )
)
    + 0

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Esmee,

 

Please remove 'person' filed and try to use below formula:

measure =
CALCULATE (
    SUM ( Blad1[amount] );
    FILTER (
        ALL ( Blad1 );
        Blad1[date] < MAX ( Blad1[date] )
            && Blad1[persoon] IN VALUES ( Blad1[persoon] )
    )
)
    + 0

Regards,

Xiaoxin Sheng

Esmee's avatar
Esmee
Frequent Visitor
8 years ago

Thanks! It works!