Forum Discussion
Count Rows and then sum them on a timeline
Hello guys, First of all, I can't create any index coloumns because its a live connection and Im not the Admin. my Problem: I want to add the sum of each day to the next day. I have the date ...
Anonymous , hope you have date in date or fact tables
A measure like
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))
or
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(Sales),Sales[Sales Date] <=max(Sales[Sales Date])))
Anonymous , hope you have date in date or fact tables
A measure like
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))
or
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(Sales),Sales[Sales Date] <=max(Sales[Sales Date])))