maximum revenue

Hi DeEviloN ,

Here I create a easy sample to have a test.

Revenue by Month = 
CALCULATE(SUM('Table'[Revenue]),ALLEXCEPT('Table','Table'[Year],'Table'[Month]))

Current Month Revenue = 
CALCULATE([Revenue by Month],FILTER(ALL('Table'),'Table'[Year] = YEAR(TODAY())&&'Table'[Month] = MONTH(TODAY())))

Max Month Revenue = 
MAXX(FILTER(ALL('Table'),'Table'[Year] = YEAR(TODAY())),[Revenue by Month])

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.