Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
jesusssss
Helper II
Helper II

Request for assistance in creating cumulative measure of warranties two years ago

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.

1 REPLY 1
TomasAndersson
Solution Sage
Solution Sage

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
    )
)  

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Kudoed Authors