Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

YTD Running Total Chart

I am trying to create a chart showing the running cummulative total by day for the current fiscal year. Here is the measure I am using:   Total Proposed Project Costs YTD = TOTALYTD( [Total Prop...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

Would you like to show total Ytd values for current year
(eg, this year2019, show Ytd values from 2019/1/1 to today)

Measure = TOTALYTD([sum cost],'calendar'[Date],'calendar'[Date]<=TODAY()&&YEAR('calendar'[Date])=YEAR(TODAY()))

Or for current year 2019, show values from 2018/7/1 to 2019/6/30?

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.