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.
Super UserYou are welcome. The formula should work ireespective of the months that fall in the year. I will need to see yoru file with your formula. I will make changes there.
Helper I- Ashish_Mathur
Hi,
The dates in Data Table are wrong. They all belong to January. Please recheck.
- Catherine84Hi Ashish
https://1drv.ms/u/s!AmdPdgYKa-3ncBrkMbDOVZa6Ia0
Updated the the date. But the rolling still not showing correctly. When I take quarter from data tab and from calendar , seems to show different data as well!
Thanks!- Ashish_Mathur
Hi,
In the First visual, i dragged year and quarter from the Calendar Table. Also, in the slicer, drag the Year from the Calendar Table.