Hi
I've created a running total column by date and criteria, first I used ALLEXCEPT , but then ALL and VALUES
so;
This was pretty much trial and error, and I'm not quite sure why I need the calculatetable or what it's doing, is it acting as a filter
so = Agency.
Richard.
I've created a running total column by date and criteria, first I used ALLEXCEPT , but then ALL and VALUES
so;
Excel Formula:
RTColumn :=
CALCULATE (
SUM ( Table1[Sales] ),
FILTER ( ALL ( Table1 ), Table1[Date] <= EARLIER ( Table1[Date] ) ),
CALCULATETABLE ( VALUES ( Table1[Agency] ) )
)This was pretty much trial and error, and I'm not quite sure why I need the calculatetable or what it's doing, is it acting as a filter
so = Agency.
Richard.
