Hi all, has anybody an idea how to dynamically divide in a dataflow ? The above is basically "Cube divided by number of months in the past minus 1". getting the month from today minus - 1 doesn't do the trick.
Thanks , maik
Hi @Maik Burghardt ,
it would be most helpful if you told us what you are trying to achieve.
From the logic that I can see, I would assume that you need the moving average of the last months to be pushed into the target (which, by the way, should not have any reference function applied). Is that correct? If so, what is the time dimension of the source- and the target cube?
Could you provide an XLS mockup of source- and target data for comparison? Best, Helmut
Hi @Helmut Heimann not sure if that helps and yes you are right. it is the moving average of the past months.
The reference I use to determine current year and previous year since this the setup of the screen.
