SAC Model calculations - YoY (function) and MoM/WoW/DoD

[hadar_k]

How can I create a model calculation for YOY, MoM,WoW,DoD .

my model has sales [measure] per day [Date dimension].

I saw the YOY built in function but thought maybe someone used that Iterate function to build the same for the rest of the granularities.

MoM = (Current Month - Prev. month ) / Prev. month

same for week and day.

[hadar_k]

Hi Nikhil Anand,

Amazing! thanks for the quick response.

everything worked, and planning to implement as a default calculation for each new model going forward.

[N1kh1l]

hadarkuint

Great. Could you close the thread by accepting the helpful answer.

Br.

Nikhil