Forum Discussion
Group Running total for date and type
Thank you all for the guidance,
I found the desired result through the use of "AllExcept"
ToDate=CALCULATE (
SUM ( Table1[Value] ),
FILTER (
ALLEXCEPT ( Table1, Table1[Type] ),
Table1[Date] <= MAX ( Table1[Date] )
)
)Just preliminary, but i think it does what i'm looking for...
Love the forum.. thanks for giving the guidance that led me to a solution that works.
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist
Once you have a date dimension, use that in your measure to get the running total and also in the visualization.