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.
Hello again.
Still cannot figure out the DAX to solve my issue:
First column is yearmonth
Second column is monthly sales
Third column is cumulative sales since the launch of the product (e.g., 659 = 655+4), calculated via the following Measure:
Fourth column is rolling 3 month sum of Second column (e.g. 64 = 28+4+32), calculated via the following Measure
Could anyone please help ?
Thank you in advance.
Solved! Go to Solution.
Sorry, I'm not sure what you mean. I believe the measure creates a cumulative sum of your rolling 3 month sales.
"Fifth column ... WHAT IS THE MEASURE'S EXPRESSION for the 3M_Rolling_CUMULATIVE_Sales?"
Isn't that what you need?
Proud to be a Super User!
Paul on Linkedin.
Try:
3 Month Cumulative =
SUMX (
SUMMARIZE (
FILTER (
ALL ( 'Calendar' ),
'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
),
'Calendar'[YearMonth],
"3MonthRSales", [3M_Rolling_Sales]
),
[3MonthRSales]
)
Proud to be a Super User!
Paul on Linkedin.
Getting close: This created the cumulative sum of the total column since product launch. How limit that to a 3 month rolling sum ?
Sorry, I'm not sure what you mean. I believe the measure creates a cumulative sum of your rolling 3 month sales.
"Fifth column ... WHAT IS THE MEASURE'S EXPRESSION for the 3M_Rolling_CUMULATIVE_Sales?"
Isn't that what you need?
Proud to be a Super User!
Paul on Linkedin.
Awesome ! Actually it worked great. Previous issue was myy mistake. Was taking the wrong variable !!
Unfortunately, it does not work. This is the formula I used in Column 4 (with LASTDATE vs. MAX), but still gives me same output 😞
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |