Forum Discussion

DeEviloN's avatar
DeEviloN
Helper III
4 years ago
Solved

maximum revenue

help me please. I have a list of organizations from the beginning of the year and their revenue, I need to show the maximum monthly revenue from the selected organization. Let's say I calculated the ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

DeEviloN's avatar
DeEviloN
Helper III
4 years ago

Shows this month's revenue, not the maximum