Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
)
)
User | Count |
---|---|
51 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
112 | |
52 | |
42 | |
26 | |
22 |