Forum Discussion

MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
4 years ago

cumulative 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...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  MasterSonic ,

You can try modifying the function to the following form:

cumulative = 
var AB = SUM('Col2'[Column])
return
CALCULATE(
SUM(
'Col1'[10]),
FILTER(
ALLSELECTED('Col2'[Date]),
'Col2'[Date]<= MAX('Col2'[Date])&&
'Col2'[Date]<>BLANK()
))

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly