Forum Discussion
Solved
Show multiple rolling average % Diff
I've been asked to present the percentage difference in the rolling averages of Products Shipped vs Products Forecasted. I need to be able to show by Product, and within the provided 2 year time fra...
You could try creating a parameter table with values 3, 6, 9, ... 24. Add this field to your visual and define the variable NumOfMonths as SELECTEDVALUE ( ParameterTable[Number of Months] ).
Man you just saved me a heap of time. Thank you!
Glad to hear that!
You could try creating a parameter table with values 3, 6, 9, ... 24. Add this field to your visual and define the variable NumOfMonths as SELECTEDVALUE ( ParameterTable[Number of Months] ).