Forum Discussion
Solved
Group Running total for date and type
Working on this, and i'm stuumped I can get to group riunning toital by date, but not by Type/Date combined Any help would be sorely appreciated Type Date Value a 1/1/2022 1 a 2/1...
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.
