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 tabl...
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)
	)
))

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Share the download link of your file.

samuelnh's avatar
samuelnh
Frequent Visitor
8 years ago

Hi - do you mean the link to the data that I'm using, etc?

 

Thanks,

 

Sam

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Yes. The download link of your .pbix file.

    • samuelnh's avatar
      samuelnh
      Frequent Visitor
      8 years ago

      It contains commerically sensitive information. Is it standard to share all of the data one is working on?

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Dummy the dataset.