Weekly difference daily data

[alexandernatale]

Hello everybody,

I have a problem that has been haunting me for several days. I have a table with this data:

| date | quantity |

Quantity is the daily stock of the warehouse.

I have a table as a master calendar which shows the date, week, year, etc.

My goal is to calculate the weekly variation ... how can I do?

I attached the tables..

data table:

 

expected result:

 

 

part of master calendar

 

[Taoufiq_Zarra]

@alexandernatale 

if I understood correctly : dimension Week and measure sum(TIR) ?

[MayilVahanan · Accepted solution]

Hi @alexandernatale 

Try like below

Dim: Week

Measure: Max(Aggr(RangeSum(Above(Sum(TIR)-Above(Sum(TIR),1),0, RowNo())),Week,Date))

[alexandernatale]

@MayilVahanan ehi...you're great!!!! P E R F E C T! 

Thank you so much!