Forum Discussion
Running Total
- 6 years ago
Anonymous , issue is no clear with description you can try
Saving Running Total test = CALCULATE([Total Usage Savings],
FILTER(ALLselected('Dates'[Date]) ,
'Dates'[Date] <= MAX('Dates'[Date]
)))for yearly you can also try ytd
YTD Sales = CALCULATE([Total Usage Savings],DATESYTD('Date'[Date],"12/31"))
- Anonymous6 years ago
Anonymous You can get this working by using this.
Test Running Total = Calculate( [Total Savings], FILTER( ALLSELECTED(Dates), 'Dates'[Date] <= MAX(Dates'[Date]) ) )However, if your Dates table has future date this behaves strange.
I couldn't crack that, this happens because of the ALLSELECTED. Seems like I need to revisit ALLSELECTED which is pretty tough to master.Perhaps Greg_Deckler or Anonymouscan explain this.
Thanks and Regards
- 6 years ago
hi Anonymous
For your case, this formula should work
Saving Running Total 3 = CALCULATE([Total Savings],FILTER(ALLSELECTED('Dates') ,'Dates'[Date] <= MAX('Dates'[Date]) ))or
TOTALYTD may meet your requirement too
Saving Running Total 4 = TOTALYTD([Total Savings],Dates[Date])Regards,Lin
hi Anonymous
For your case, this formula should work
or
TOTALYTD may meet your requirement too
v-lili6-msft Yes, this did the trick and it helped, i was including the Date[Date] while Allselection, thanks to you and the whole team who helped me and i fixed the code while Allselecting only Date exactly like you stated