Forum Discussion

LouisB's avatar
LouisB
Frequent Visitor
7 years ago
Solved

Compare 2 values that are 1 week separated

Hello guys,   I was looking at a method to compare 2 values (of the column Total) separated by 1 Week. The data are the number of Stars of different Apps. I just want to have the number of new sta...
Need Help
  • ofirk's avatar
    ofirk
    7 years ago

    Hi,

    I think this column would work (replace Table1 with your table name...):

     

    column = [Total] - SUMX(FILTER(Table1, [Brand] = EARLIER([Brand]) && (EARLIER([Date]) - [Date])= 7), [Total])
ofirk's avatar
ofirk
Icon for Resolver II rankResolver II
7 years ago

Hi,

I think this column would work (replace Table1 with your table name...):

 

column = [Total] - SUMX(FILTER(Table1, [Brand] = EARLIER([Brand]) && (EARLIER([Date]) - [Date])= 7), [Total])
  • LouisB's avatar
    LouisB
    Frequent Visitor
    7 years ago

    You are awesome ofirk !