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))your formula isnt that much different to mine
ill see what i can do to replicate this in a sample document
any particular reason why this formula would work and then all of a sudden a month goes missing? there has been data in June 2020 before as i look at it daily
Anonymous , In your formula, instead of last day try Max and check