Forum Discussion

anony711's avatar
anony711
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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    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

anony711's avatar
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's avatar
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