Forum Discussion
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 ...
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
