Forum Discussion
Solved
Calculate YTD Goal based on current month
I have a goals table for my team which has a monthly goal per user. I need a way to show the goal YTD in a report so that I can compare it to the actuals. Currently I have a goals table in my da...
Yes it is the sum of all the goals up to the current date. I have actually found the solution.
Using the following IF statement in the measure did the trick. Thanks to Sam McKay at EnterpriseDNA for the solution.
IF (LASTDATE(Dates[Date]) > TODAY(), BLANK(), CALCULATE([Total Goal], DATESYTD(Dates[Date])))
msornakumar
Advocate III
Advocate IIIHi ,
How to calcuate the goal YTD ? Is it SUM of the goals till current month or How it needs to be calculated ?
Yes it is the sum of all the goals up to the current date. I have actually found the solution.
Using the following IF statement in the measure did the trick. Thanks to Sam McKay at EnterpriseDNA for the solution.
IF (LASTDATE(Dates[Date]) > TODAY(), BLANK(), CALCULATE([Total Goal], DATESYTD(Dates[Date])))