cancel
Showing results for
Search instead for
Did you mean:
Frequent Visitor

## find the MAX value of all year by year

Hi,

i have sales by date (for many years), and i would like to obtain the MAX value of sales by year

Example :

2016 : 324000

2017 : 345000

2018 : 298000

the example below is the sum by year, and I would like to obtain the result : 345000

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Established Member

## Re: find the MAX value of all year by year

You could try MAXX:

```Sales Amount =
SUM( Table[Sales] )

Highest Yearly Sales =
MAXX ( VALUES ( Date[Year] ), [Sales Amount] )```
2 REPLIES 2
Established Member

## Re: find the MAX value of all year by year

You could try MAXX:

```Sales Amount =
SUM( Table[Sales] )

Highest Yearly Sales =
MAXX ( VALUES ( Date[Year] ), [Sales Amount] )```
Super User

## Re: find the MAX value of all year by year

Hi @coollehavre,

You should use a measure like this:

```Max of sales =
CALCULATE (
MAXX (
ADDCOLUMNS ( ALL ( Table[Date].[Year] ); "Sales Max"; [Sales Total] );
[Sales Max]
)
)```

I'm assuming you have a Sales total measure that his the sum of sales,if not change that part by SUM(Table[Sales]).

If you want to have the sum of sales and on the total of that column the maximum use this other measure:

`Column total = IF(HASONEFILTER(Table1[Date].[Year]);[Sales Total];[Max of sales])`

Regards,

MFelix

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

## Helpful resources

Announcements

#### New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,062)