Forum Discussion
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...
v-yanjiang-msft
Community Support
Community SupportHi emuller ,
I create a sample and reproduce your problem.
Simply modify the formula to:
RunningTotal =
CALCULATE (
COUNT ( 'Table1'[ID] ),
FILTER ( ALL ( 'Table1' ), 'Table1'[Date] <= MAX ( 'Table1'[Date] ) )
)
Get the correct result:
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the response.
While this works to create a table like you showed, I still cannot create a Line Chart that shows the quarterly intervals. I believe the issue is when I add another field to the legend I somehow cannot show quarters anymore
- v-yanjiang-msft
Hi emuller ,
Glad you find the cause, if you need further help, I need the sample data without sensitive data to dig.
Best regards,
Community Support Team_yanjiang