Forum Discussion
Caz_16
Helper II
5 years agoCumulative Calculation to Date
Hi all, So I found this great formula on the forum for calculating a measure for FYTD, and then having the lines stop and not continue on until the end of the calendar year. However, there is on...
- 5 years ago
Anonymous ,
I can see what you were doing, working with only variables, but unfortunately It produced the same thing that my previous formula did. However, you did set me on track for what I was looking for. I had to replace the ALL(TIME[Entry Date]) with ALLCROSSFILTERED(TIME[Entry Date]), because the ALL was still enforcing the filtering coming from the outside table. ALLCROSSFILTERED got rid of those filters coming from the table where I keep my Time Entry Categories. So my final formula wound up being:
Cumulative Cost by Day = VAR LastDate1 = CALCULATE(LASTDATE('TIME'[EntryDate]),ALLCROSSFILTERED('TIME')) RETURN IF( SELECTEDVALUE('Calendar Table'[Date])> LastDate1, BLANK(), CALCULATE( SUM('TIME'[COST]), FILTER(ALLSELECTED('Calendar Table'[Date]), 'Calendar Table'[Date] <= MAX('Calendar Table'[Date]) ) ) )Thank you for your time and reply.
amitchandak
Super User
5 years agoCaz_16 .Have you tried datesytd?
example
YTD = CALCULATE(SUM('Time'[Duration]),DATESYTD('Date'[Date],"12/31")) // Change end date based on your FY