Forum Discussion
Incremental line graph
Please could you help guiding me on this? At the moment I have: Total Incidents is DISTINCTCOUNT of report ID Total Incidents = DISTINCTCOUNT('Report_Incidents'[ID])+0 Month ...
Oh, if you want it to reset within a specific partition, check out the WINDOW function. https://learn.microsoft.com/en-us/dax/window-function-dax
Example 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] )
Thank you for your help and suggestion, I ended up using: