Highest value from a column based on dates

[anony711]

Hello everyone, 

I have been stuck on this problem for a while and while it may seem like a easy question- I cant seem to figure it out.

My problem is: I would like to get a summary table for the max value(highlighted) in yellow for each month/year.

E.g. for Oct-2021 its 89 and Nov-2021 its 164 etc

Any help is appreciated. 🙂

[anony711]

Thank you all

[v-cgao-msft · Accepted solution]

Hi @anony711 ,

If you want a calculated table.

Table 2 = 
SUMMARIZE (
    'Table',
    'Table'[Cal(Mon/Year)],
    "Max of each month", MAX ( 'Table'[Max of each month] )
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Luis98]

Hi @anony711 ,

So if you have a table visualization and you want to get the maximum value you can summarize the value:

[Luis98]

Hi @anony711 ,

You have to select the column Call(Mon/Year), right click group by, and fill like this;

[anony711]

Hi @Luis98 

Thank you for your reply.

I forgot to mention that this a summarised table in PowerBI so a calculated column or measure is what I am looking for. 

Thank you once again

[BA_Pete]

Hi @anony711 ,

You just need the following mesure:

_maxOfMax = MAX(yourTable[Max of each month])

Put this is a visual with one of your other date fields and it will give you what you want.

Pete