Get Rolling Maximum

Question

Hi,&nbsp;I'm trying to get the maximum rolling value in a table, till each date.&nbsp;Here's the table, with the desired output column:&nbsp;DateProductValueDesired Output (Highest Value Till Date)Jan-22A2020Feb-22A2424Apr-22A2824Jun-22A1424Jul-22A2024Sep-22A3030Nov-22A2930Dec-22A3232Feb-23A1832Apr-23A1732Jun-23A1632When we add a date filter through a slicer, the dynamic max value should be recalculated like this (select date&gt;= June 2022)Or when we select another product, the max value should be recalculated according to the filtered view.&nbsp;DateProductValueDesired Output (Highest Value Till Date)Jun-22A1414Jul-22A2020Sep-22A3030Nov-22A2930Dec-22A3232Feb-23A1832Apr-23A1732Jun-23A1632&nbsp;I've written the following code but it's not recalculating the max value when applying the date filter through a slicer.&nbsp;Dynamic MAX = CALCULATE(MAX('Table'[Value], KEEPFILTERS('Table'[Date] &lt;= MAX('Table'[Date])), REMOVEFILTERS('Table'[Value]))&nbsp;Any pointers?Thank you in advance!

anonymous · Accepted Answer

Hi&nbsp;PiyushBQ&nbsp;,
&nbsp;
Based on your logic described, the desired output in Apr-22 should be 28 instead of 24.

I create the dynamic measure as
Dynamic MAX = CALCULATE(MAX('Table'[Value]),FILTER(ALLSELECTED('Table'),[Product]=MAX('Table'[Product])&amp;&amp;[Date]&lt;=MAX('Table'[Date])))

The result changes when the slicer is filtered.

&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Get Rolling Maximum

2 Replies

Related content

Running Maximum

Rolling accumulation

Rolling accumulation

Calculating maximum of rolling sum

Rows - Maximum Date

Date	Product	Value	Desired Output (Highest Value Till Date)
Jan-22	A	20	20
Feb-22	A	24	24
Apr-22	A	28	24
Jun-22	A	14	24
Jul-22	A	20	24
Sep-22	A	30	30
Nov-22	A	29	30
Dec-22	A	32	32
Feb-23	A	18	32
Apr-23	A	17	32
Jun-23	A	16	32