Forum Discussion
Quick measure - Moving average
You can write something like
=IF( [OtherMeasureInChart]<>Blank(), [Rolling Avg Measure] )
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
Thanks for your answer,
I've found a solution to my problem, for a 3 month rolling average i have to write "-2" instead of "-3".
I have now another question.
You can see in my chart that rolling average is calculated for future month (January, February and March 2019). How can i stop the measure so that i don't have a wrong presentation?
Thanks
Martin
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
Your simple trick saved my day..
Thanks mate