How to plot rolling sum in column chart for everyday in a month

[inikhilpv]

Hi,

I need to plot a column chart with rolling sum of sales. For everymonth it should show the rollingsum of sales till the end of the month. If there is no sales on a particular day, it should show the rolling sum till the previuos day.

I'm using the below DAX to find the rolling sum.

RollingSum =
CALCULATE(
SUM (Sales [sales],
FILTER(
ALLSELECTED('Date'),
'Date'[Date] <= MAX('Date'[Date])))

This is working fine. But when I apply the slicer (sales person id) it is not showing the date on the x axis if there is no sales transaction on that particular day as given below.

day wise sales chart is given below.

Please help me to have all the days displayed on the above chart evenif there is no transaction happend on those days.

[bhanu_gautam]

@inikhilpv , Try using 

Create a Date Table: Ensure you have a date table that includes all the dates in the range you are interested in. This table should not have any missing dates.

Create a Relationship: Make sure there is a relationship between your Sales table and the Date table.

Modify the DAX for Rolling Sum: Adjust your DAX formula to use the Date table.

RollingSum =
CALCULATE(
SUM(Sales[sales]),
FILTER(
ALLSELECTED('Date'),
'Date'[Date] <= MAX('Date'[Date])
)
)

[inikhilpv]

I did the same way. Created a date table and related to sales date in the sales table. Still I'm not able to plot the rolling total if there is no sales on a particular day.