0
is there a way to calculate an mesure avarage for the last year from yestrday?
I want to calculate a moving avarege of a mesure that will be always take the period of a year from yesterday or preveious week back.
can someone help me with this calculation?
1 reply
-
Hi
What is your data source? Is this an OLAP cube or a Pyramid Model? (As I recall it is OLAP - correct me if I'm wrong).
Do you have a hierarchy that is just date or do you use a date hierarchy?
Can you add a screenshot of your data?
Thank you