year over year growth calculation |
|
can any one help me for finding year over year growth calculation in mdx(ssas).
where i have data for current year(6 month) and previous year(12 month),
so can't compare current year with previous year.
i used parallel period function, but i got full year data of previous year where i want only 6 month data as compare to current year.
so, please anyone help me. i urgently want the solution. it is very important for me.
|
Re: year over year growth calculation |
|
For period over period MDX you can look at the following link...
http://stackoverflow.com/questions/9895611/how-to-create-a-period-over-period-measurement-in-mdx
On Monday, September 10, 2012 7:49:56 AM UTC-5, shubh107 wrote:
> can any one help me for finding year over year growth calculation in mdx(ssas).
>
> where i have data for current year(6 month) and previous year(12 month),
>
> so can't compare current year with previous year.
>
>
>
> i used parallel period function, but i got full year data of previous year where i want only 6 month data as compare to current year.
>
>
>
> so, please anyone help me. i urgently want the solution. it is very important for me.
|