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 ()
    )
    )
    )
    )
     
     
     
     
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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 ()
)
)
)
)