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

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