Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulate values between two date fields

Hello,   I face an issue that looks simple but I don't find the trick.   My wish is to display on a visual the power cumulated year by year of the plants between StartDate and EndDate Our first ...
Need Help
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Please check the below picture and the sample pbix file's link down below.

     

     

    Power Measure =
    IF (
    ISFILTERED ( Dates ),
    CALCULATE (
    SUMX (
    Plants,
    Plants[Power]
    ),
    FILTER (
    Plants,
    Plants[StartDate]
    <= MAX ( Dates[Date] )
    && OR (
    Plants[EndDate]
    >= MIN ( Dates[Date] ),
    Plants[EndDate]
    = BLANK ()
    )
    )
    )
    )