Incremental line graph

Question

Please could you help guiding me on this?&nbsp;&nbsp;At the moment I have:&nbsp;&nbsp;Total Incidents is&nbsp;DISTINCTCOUNT of report ID&nbsp;Total Incidents = DISTINCTCOUNT('Report_Incidents'[ID])+0Month Name and FY are from the calendar table&nbsp;&nbsp;How do I make this line graph to appear incrementally for each year?&nbsp;Aug = Aug countSep = Aug + Sep countsOct = Aug + Sep + Oct counts&nbsp;... &nbsp;Please please, thank you very much

coreyp · Answer

I think you're looking for a cumulative sum. Try using the TOTALYTD function

anonymous · Answer

thank you, I will look at this function&nbsp;

anonymous · Answer

Tried TOTALYTD but I don't quite understand, however I came up with the below but I would like to have the Measure reset in Aug each year&nbsp;Please thank you

coreyp · Answer

Oh, if you want it to reset within a specific partition, check out the WINDOW function.&nbsp;https://learn.microsoft.com/en-us/dax/window-function-daxExample 2 should be quite useful:RunningSum = SUMX ( WINDOW ( 1, ABS, 0, REL, ALLSELECTED ( 'Date'[Fiscal Year], 'Date'[Month Number Of Year] ), PARTITIONBY ( 'Date'[Fiscal Year] ) ), [Total Sales] )

anonymous · Answer

Thank you very much for your patience, my DAX knowledge is &lt;0.&nbsp;&nbsp;I will keep researching.Thanks again&nbsp;

Forum Discussion

Related content

Line Graph Visual

Line Graph Errors

Cropped Graph (Line Graph)

Help with line graph sorting

Increment Refresh