Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Incremental line graph

Please could you help guiding me on this? 

 

At the moment I have: 

pi355113_0-1695869718855.pngpi355113_1-1695869748386.png

 

Total Incidents is DISTINCTCOUNT of report ID 

Total Incidents = DISTINCTCOUNT('Report_Incidents'[ID])+0

Month Name and FY are from the calendar table 

 

How do I make this line graph to appear incrementally for each year? 

Aug = Aug count

Sep = Aug + Sep counts

Oct = Aug + Sep + Oct counts 

...

 

Please please, thank you very much

6 REPLIES 6
Anonymous
Not applicable

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 

pi355113_0-1695948892567.png

Please thank you

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] )

Anonymous
Not applicable

Thank you for your help and suggestion, I ended up using: 

pi355113_0-1695958658770.png

 

Anonymous
Not applicable

Thank you very much for your patience, my DAX knowledge is <0.  

I will keep researching.

pi355113_1-1695950689800.png

Thanks again

 

CoreyP
Solution Sage
Solution Sage

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

Anonymous
Not applicable

thank you, I will look at this function 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.