calculation on a rolling
1 Topic
Dax for conducting a calculation each month on another measure
I have a report which shows a static monthly forecast and a measure that is linked to a parameter to allow the user to increase or decrease by a % the incoming and closure forecast per month. The measure should show the static forecast plus or minus the increase or decrease in incoming /closures. Let's say we had 1000 static forecast for July and all months during the year , and 100 incoming and 50 closure monthly were set on the parameter the dynamic measure should show 1050 as the net is +50 this works fine for the current month but then next month the measure takes the 1000 + 50 whereas I want it to take the 1050 + the 50 so return 1100. the problem I'm having is getting the 1050 to roll forward and be used in the next months calculation, easy to do in excel but not power bi tried using offset but it just doesn't return the new calculation of 1050 any ideas ?Solved1.7KViews2likes8Comments