Minimum point of a cumulative frequency

[SarahESkells]

Hello

Is it possible to write a formula/DAX to find the minimum point in a cumulative frequency? I have the below data and when selecting this date range it would be great to see that the lowest point is -48.25, ideally I'd like to have cards that just shows the cumulative total of 358.20 and the lowest point of 48.25 for that date range selected. The cumulative total is a measure

Thanks in advance

[PaulDBrown]

Can you post a screenshot of the error, and which table does the DateMonth come from?

[SarahESkells]

Hi Paul, I've just tried this again and its working fine. Thank you for your help

[PaulDBrown · Accepted solution]

For a card try:

Min Cumulative total = MINX(ALLSELECTED(Table[DateMonth]), [Cumulative total])

Where Table[DateMonth] is the field shown in your example (so ideally from a Date Table)

[SarahESkells]

Hi Paul

Thank you for your response, I've tried this but I get an "The end of the input was reached" error?