Show Cumulative trend in a line chart

[gautampruthi]

Hi I have a data in this format 

Employee Code, Employee Last date , Reason, Academic Year 

I want to create a line chart to show Cumulative trend of employee leaving in the academic year  starting from Sep till July

I am using this measure to calculate the trend but when i use it in line chart it show zig zag but i need it to be cumulative

CurrentYearWithdrawals =

CALCULATE(

  SUM(ECE[Custom]),  // Count the number of rows (withdrawals) in ECE, created a custom column

   FILTER(

       ECE,

       ECE[Academic Year] = "23/24" && (SCE[Enrolment Status] = "W" || SCE[Enrolment Status] = "S")  // Current academic year and stac condition

   )

)

[lbendlin]

You are missing the cumulative part.  You need to get the "current"  date and then sum up all values in the current period (academic year) that have dates less than or equal to that.

Please use Quick Measures to see samples of cumulative measures.