Forum Discussion

nvanzyl24's avatar
nvanzyl24
Regular Visitor
3 years ago

Rolling Average - Stop

Hi. I have used the Quick measure to create a rolling average of 3 and 12 months. On the chart the measures go beyond where there is no data. Any suggestions to stop this?  
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Change the result so that the measure returns BLANK when the [Total] is BLANK

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523