Minimum and Maximo in one matrix per year

[Syndicate_Admin]

Hello Community.

I have the following problem

I need to show the Minimum and the Maximo of Capital, Interest and Interest Mora, for each Month and for Each Year shown in the Matrix.

But I haven't found the calculation, as you can see the values I show by Dodne Range I'm clearly miscal calculating the data.

How should it be the right formula?

[Syndicate_Admin]

Here's what it should be:

[amitchandak · Accepted solution]

@Syndicate_Admin , Try like

calculate(maxx(values(Table[Mes NOs]), [Captial]), allexcept(Table, Table[year]))

[Syndicate_Admin]

Hello, it almost works for me, gives me the maximum of registration and on this occasion I look for the maximum of the stretch.

Maximo - calculate(maxx(values(TABLE[MORA DAYS]), [Capital Amount]), allexcept(TABLE, Calendar[Year]))