Forum Discussion
MasterSonic
Helper IV
Helper IVcumulative sum or count
Hi guys, I have 2 tables - first with uniqe codes second with dates and category (A,B,C) I have created this : Count of dates = CALCULATE( sum('Col1'[code]), FILTER( A...
amitchandak
Super User
Super UserMasterSonic , You should always use a separate date table(Joined with date of your table) for that. and in visual use columns from that date table
Count of dates =
CALCULATE(
sum('Col1'[code]),
FILTER(
ALLSELECTED('Date'[Date]),
ISONORAFTER('Date'[Date],MAX('Date'[Date]), DESC)
)
Running Total/ Cumulative: https://www.youtube.com/watch?v=h2wsO332LUo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=41
)