Forum Discussion

samuelnh's avatar
samuelnh
Frequent Visitor
8 years ago
Solved

Remove future values for running total

Hi all

 

I want to create a running total chart for project planning showing the amount of work my team has done compared to budget. I have used the running total quick measure and have a date table.

 

However, the charts I've created show a flat line for the future. The easiest to show with a picture:

 

I want to be rid of the flat horizontal lines in this. Should I change my measure or is there a way to do this with the chart itself?

 

The measure formula is as follows:

 

value_scheduled running total in Month_Year = 
CALCULATE(
	SUM('timesheets 16-04 to 18-03'[value_scheduled]),
	FILTER(
		ALLSELECTED('Dates'[Month_Year]),
		ISONORAFTER('Dates'[Month_Year], MAX('Dates'[Month_Year]), DESC)
	)
)

 

Data Here:

https://ufile.io/5twet

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this for value_scheduled running total in Month_Year

     

    =if(ISBLANK(SUM('timesheets 16-04 to 18-03'[value_scheduled])),BLANK(),CALCULATE(
	SUM('timesheets 16-04 to 18-03'[value_scheduled]),
	FILTER(
		ALLSELECTED('Dates'[Month_Year]),
		ISONORAFTER('Dates'[Month_Year], MAX('Dates'[Month_Year]), DESC)
	)
))

    Try this forvalue_worked running total in Month_Year

     

    =if(ISBLANK(SUM('timesheets 16-04 to 18-03'[value_worked])),BLANK(),CALCULATE(
	SUM('timesheets 16-04 to 18-03'[value_worked]),
	FILTER(
		ALLSELECTED('Dates'[Month_Year]),
		ISONORAFTER('Dates'[Month_Year], MAX('Dates'[Month_Year]), DESC)
	)
))

     

9 Replies