Forum Discussion

emuller's avatar
emuller
Frequent Visitor
3 years ago

Need Help Displaying a Rolling Count by Quarter

Hi All,   I have been trying to specifically display the quarter/year in a line chart. I have created a measure that works (sometimes) to show the rolling count of a field over time. When trying to...
Need Help
emuller's avatar
emuller
Frequent Visitor
3 years ago

Hi Ashish_Mathur,
Thank you for your advice.
I just tried this and do not think it is what I need. I still cannot fork down to the quarter level. Also I do not need YTD just a rolling count, regardless of time.

 



  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Revise the measure to

    Running count = calculate([count],datesbetween(calendar[date],minx(all(calendar),calendar[date]),max(calendar[date])))

    Ensure that the Year and quarter on the X-axis of the visual are dragged from the Calendar Table.

    Hope this helps.