Forum Discussion

daniel1308's avatar
daniel1308
Regular Visitor
2 years ago
Solved

Return Date on S-Curve

Hi everyone.

 

I have this measure:
Cumulative_Baseline_Units =
CALCULATE(
SUM('Schedule Info'[Value]),
FILTER(
ALLSELECTED('Schedule Info'),
'Schedule Info'[Units] = "Baseline Units" && 'Schedule Info'[Date] <= MAX('Schedule Info'[Date])
)
)


I now want to create a new measure for my table which points at which point the maximum is reached. ANy ideas?

 

Need Help
  • daniel1308's avatar
    daniel1308
    2 years ago

    Hi, thanks so uch for your assistance. This is what I landed up doing:

    Max_Cumulative_Actual_Units =
    CALCULATE(
    MAXX(
    ALLSELECTED('Schedule Info'),
    CALCULATE(
    SUM('Schedule Info'[Value]),
    FILTER(
    ALLSELECTED('Schedule Info'),
    'Schedule Info'[Units] = "Actual Units" && 'Schedule Info'[Date] <= EARLIER('Schedule Info'[Date])
    )
    )
    )
    )

    and then:

    Date_Max_Cumulative_Actual_Units_Reached =
    CALCULATE(
    MIN('Schedule Info'[Date]),
    FILTER(
    ALLSELECTED('Schedule Info'),
    'Schedule Info'[Units] = "Actual Units" &&
    CALCULATE(
    SUM('Schedule Info'[Value]),
    FILTER(
    ALLSELECTED('Schedule Info'),
    'Schedule Info'[Units] = "Actual Units" && 'Schedule Info'[Date] <= EARLIER('Schedule Info'[Date])
    )
    ) = [Max_Cumulative_Actual_Units]
    )
    )

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    2 years ago

    Hi daniel1308 - can you create a measure to calculate the maximum value of your cumulative 

     

    Max_Cumulative_Baseline_Units = MAXX(
    ALLSELECTED('Schedule Info'[Date]),
    [Cumulative_Baseline_Units]
    )

     

    use the above measure to Identify the Date of Maximum Cumulative Value for compare

    Date_Max_Cumulative_Baseline_Units =
    CALCULATE(
    MAX('Schedule Info'[Date]),
    FILTER(
    ALLSELECTED('Schedule Info'),
    [Cumulative_Baseline_Units] = [Max_Cumulative_Baseline_Units]
    )
    )

     

    I hope this works 

     

    Please check

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

  • daniel1308's avatar
    daniel1308
    Regular Visitor
    2 years ago

    Hi, thanks so uch for your assistance. This is what I landed up doing:

    Max_Cumulative_Actual_Units =
    CALCULATE(
    MAXX(
    ALLSELECTED('Schedule Info'),
    CALCULATE(
    SUM('Schedule Info'[Value]),
    FILTER(
    ALLSELECTED('Schedule Info'),
    'Schedule Info'[Units] = "Actual Units" && 'Schedule Info'[Date] <= EARLIER('Schedule Info'[Date])
    )
    )
    )
    )

    and then:

    Date_Max_Cumulative_Actual_Units_Reached =
    CALCULATE(
    MIN('Schedule Info'[Date]),
    FILTER(
    ALLSELECTED('Schedule Info'),
    'Schedule Info'[Units] = "Actual Units" &&
    CALCULATE(
    SUM('Schedule Info'[Value]),
    FILTER(
    ALLSELECTED('Schedule Info'),
    'Schedule Info'[Units] = "Actual Units" && 'Schedule Info'[Date] <= EARLIER('Schedule Info'[Date])
    )
    ) = [Max_Cumulative_Actual_Units]
    )
    )