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 revenue for the current month, but I want to compare it with the maximum revenue of this organization. For example, in the current month, the revenue is 15, and the maximum revenue they had in February was 30, how to display it?

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.

     

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    DeEviloN ,

     

    calculate( Maxx(values('Date'[Month Year]) , [Revenue measure]), filter(allselected(Table[Organzation]) , Table[Organzation] = max(Table[Organzation]) ) )

     

    or

     


    calculate( Maxx(values('Date'[Month Year]) , [Revenue measure]), filter(all(Table[Organzation]) , Table[Organzation] = max(Table[Organzation]) ) )

     

    or

     


    calculate( Maxx(values('Date'[Month Year]) , [Revenue measure]), filter(allselected(Table) , Table[Organzation] = max(Table[Organzation]) ) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.