Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I am attempting to create an cumulative measure that sums all the two-year warranty amounts from two years ago until today, and I am unable to do so. I have tried various methods, but none have provided the solution that I am seeking. If anyone knows how to help me, I would greatly appreciate it. Thank you.
Hi! Don't know how your data is structured so you will have to adjust accordingly, but something like:
Cumulative last two years =
VAR __LastDate = TODAY() -- can be omitted if you define last date e.g. through a date slicer
VAR __FirstDate = EDATE(__LastDate, -24)
return
CALCULATE(
SUM(Table[Warranty Amount]),
FILTER(ALL(Dates),
Dates[Date] >= __FirstDate &&
Dates[Date] <= __LastDate
)
)
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 6 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 12 | |
| 11 | |
| 9 | |
| 8 | |
| 7 |