DAX Create table with each day of a month and accumulated sales for each day

[Anonymous]

Hello,

From a simple fact table of sales which shows the date of the sale and the amount ($) sold, connected to a Calendar table, I'm trying to find some function or group of functions that return a 2 column table according to a month defined in the function: Day of the month | Accumulated Sale

The accumulated sale to each of those days of the month, would also need to consider the sales of previous months.

I've tried using SUMMARIZE per day, and an acumulative function with CALCULATE and ALL, but I think it is not working because of the way SUMMARIZE creates the filter context.

Thank you very much,

Jesus 

[amitchandak]

@Anonymous , Sample data would have helped. With help from a date table

example

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[date])))

Without date table 

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(Sales),Sales[Sales Date] <=max(Sales[Sales Date])))

[Anonymous]

Not clear what you're trying to do. Are you trying to create a calculated table in the model? A measure can't return a table, so it can't be a measure.

[Anonymous]

Yes, I want to create a calculated table in the model, or most probably I would use it as a virtual table in a measure.