cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
coollehavre Frequent Visitor
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
AkhilAshok Established Member
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] )

View solution in original post

2 REPLIES 2
AkhilAshok Established Member
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] )

View solution in original post

Super User
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

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

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

Power Platform World Tour

Find out where you can attend!

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