Forum Discussion
Rolling 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.
Hi,
I cannot understand your data. What does the Amount column in the Data Table hold. Does that hold the figures for that quarter ot is it data till that specific quarter? Why have you had to compute the QTD Amount column in the Data Table?
The 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. 😀
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.