Forum Discussion
Quick measure - Moving average
You can write something like
=IF( [OtherMeasureInChart]<>Blank(), [Rolling Avg Measure] )
Thank you for your answer, that's work perfectly.
I have a last question, is it possible to remove the first 2 month of 2016 on the chart for the measure because this is not calculated on a 3 month basis due to filter applied on the report.
Thank you
Martin
Hi Anonymous
You can further wrap the entire IF function in the CALCULATE Function. Something like
=CALCULATE (
[EntireIFfunctionMeasure],
DATESBETWEEN ( Cal[Date], DATE ( 2016, 3, 1 ), MAX ( Cal[Date] ) ) )
Cal[Date] - will come from your calendar table. Should be related to your transactions table
DATESBETWEEN Function - will allow you to run the calculation between set time periods. In this case the start date has been manually punched as 1st Mar 2016 by using the DATE function
I hope that works
Hi,
Thanks for your answer. It's not working as the rolling average for march is equal to march data. The calculation seems to begin in march 2016.
Anonymous
I am not sure if I have understood your question correctly.
When you say remove the first 2 months - You mean still want the rolling total to start from Jan but don't want to show Jan and Feb in horizontal axis of the chart ?
Can you please elaborate ?
Well what i want is to show a good calculation of the rolling average. With my formula the calculation only begin in march, so the rolling haverag is equal to march value. For April the calulation is (march + april)/2 wich is still incorect.
To have what i want i need to begin my measure at this date (2015;10;1) to have the rolling average for january. So is it possible to hide 2015?
Thank you for your precious help
Martin