Forum Discussion

Frequent Visitor

3 years ago

Solved

Highest value from a column based on dates

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. 🙂

Tips and Tricks

Anonymous
3 years ago
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

6 Replies

Anonymous
Not applicable
3 years ago
Hi anony711 ,

So if you have a table visualization and you want to get the maximum value you can summarize the value:
Anonymous
Not applicable
3 years ago
Hi anony711 ,

You have to select the column Call(Mon/Year), right click group by, and fill like this;
- anony711
  Frequent Visitor
  3 years ago
  Hi Anonymous
  
  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
    Super User
    3 years ago
    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
Anonymous
Not applicable
3 years ago
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
anony711
Frequent Visitor
3 years ago
Thank you all