Forum Discussion
Rolling Graph missing a months data
Hi have a rolling 3 month graph and for some reason my June 2020 numbers are missing completely ive rebuilt the graph, ensuring i didnt have any filters on and still having the issues. up until t...
Anonymous , the formula seems fine.
Just try this variation using the date from the table too
Rolling 3 = CALCULATE(SUM( 'Work Items - All history by month'[Effort] ),DATESINPERIOD('Date'[Date],ENDOFMONTH('Work Items - All history by month'[Date]),-3,MONTH))
or
Rolling 3 = CALCULATE(SUM( 'Work Items - All history by month'[Effort] ),DATESINPERIOD('Date'[Date ],MAX('Work Items - All history by month'[Date]),-3,MONTH))amitchandak
thanks for the help
both of those formula's output with a different issue. the %'s are the same for each month