Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
@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])
)
)
Proud to be a Super User! |
|
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.
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |