Forum Discussion
Helper IRolling data for 4 quarters
Hi,
Remove Account code from the column labels. Try this measure
Rolling 4 quarter sales value = CALCULATE([Sales QTD amount],DATESBETWEEN('Calendar'[Date],EDATE(MIN('Calendar'[Date]),-9),MAX('Calendar'[Date])))
Rolling 4 quarter COGS value = CALCULATE([COGS QTD amount],DATESBETWEEN('Calendar'[Date],EDATE(MIN('Calendar'[Date]),-9),MAX('Calendar'[Date])))
Hi,
In the filter section (right hand side pane), click on Year and select Do not Summarize.
Hi,
There is no mistake in my formula. I think there is a problem in the Date column of your Data Table. The 4th quarter of 2016 should be March - May of 2017, so the date should be 1 March 2017 (not 1 March 2016 - as is appearing in your PBI file). Please check.
That is all i can help with.
Helper IThe amount column holds the year to date numbers. Ie for q1 =June - Aug, q2=Aug -Nov,q3=Aug -Feb, q4=mar-may.
The QTd amount holds 3 months amount, ie q1=june -aug, q2 =sep-nov,q3=dec-feb and q4=mar-may.
I need a column that calculate rolling 4 quarters numbers. Ie if 2018 3rd quarter, I will need 2018q1+2018q2+2018q3+2017q4. For 4the quarter of 2018=2018q1+2018q2+2018q3+2018q4. 😀
Super UserHi,
There is no mistake in my formula. I think there is a problem in the Date column of your Data Table. The 4th quarter of 2016 should be March - May of 2017, so the date should be 1 March 2017 (not 1 March 2016 - as is appearing in your PBI file). Please check.
That is all i can help with.