Forum Discussion
Cumulative sum for null date value for Analysis Service source
I connected my data with Analysis Service.
I am using Issue_date, Rev, and booking for the visualization
I have the cumulative showing 0 instead of correct cumulative and my graph have 0 column chart.
what I intended to show is
This is how the table look like when
This is my formula
CALCULATE(sum(D208[Tktd_Revenue]),
FILTER(ALL('D208'[Issue_Date]),
'D208'[Issue_Date]<= MAX('D208'[Issue_Date])
)
)
Any suggestion will do. I cannot do any additional column because using Analysis Service.
Anonymous , Try like
CALCULATE(sum(D208[Tktd_Revenue]),
FILTER(ALL('D208'),
'D208'[Issue_Date]<= MAX('D208'[Issue_Date])
)
)
1 Reply
Anonymous , Try like
CALCULATE(sum(D208[Tktd_Revenue]),
FILTER(ALL('D208'),
'D208'[Issue_Date]<= MAX('D208'[Issue_Date])
)
)