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,
In the First visual, i dragged year and quarter from the Calendar Table. Also, in the slicer, drag the Year from the Calendar Table.
Thanks Ashish! Thanks for your help!! I manage to get to it ! As my calendar [year] and the Data [Year] is different, it didnt work intitally! Really appreciate all your kind help! Has learned many things from this thread! :)
Thanks a lot !
You are welcome. If my reply helped, please mark my relevant post as Answer.
hi ashish i need your help on cash flow report
Hi.
What help?
