Forum Discussion
Cumulative Max
HI ! I have a table with date and value column. I would like to calculate the cumulative total value, which I got, but also the cumulative max of the cumulative total value. I tried to use Max...
Just try calculate(max()...
Cum max = CALCULATE (
MAX('Table'[Values]),
FILTER (
ALLSELECTED( 'Table' ),
'Table'[Dates]<= MAX ( 'Table'[Dates] )))
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply, but Max does not accept acolumn form a virtual table as parameter.