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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
gautampruthi
Helper I
Helper I

Show Cumulative trend in a line chart

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
   )
)
1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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