max sales of specifics month

[Anonymous]

How can I create a measure to calculate the maximum sale of specific months?

For example: for the months of February, March and April, which was the maximum sale.

[Alex_Hasan]

Hello @Anonymous , You might take a concept from here.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Maximum-sales-of-a-of-a-specific-month-within-a-specific-year/m-p/2529717#M70897

[Nathaniel_C]

Hi @Anonymous , Would you please provide us with more detail? Can you share your data tables? I can write a measure for you, but it won't mean much if you have not provide us more detail.  If you have the totals for your months, you could use CALCULATE(MAX(mytable[montlyTotal]) if you had summed your monthly totals already.

If you would share your pbix, or dummy up some values in Excel both for current and expected data. Please copy and paste them into your post, rather than doing a picture, we may be able to help you. 

Please read this post to get your question answered more quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel