March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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. 🙂
Solved! Go to 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
Thank you all
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
Hi @anony711 ,
So if you have a table visualization and you want to get the maximum value you can summarize the value:
Hi @anony711 ,
You have to select the column Call(Mon/Year), right click group by, and fill like this;
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
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
Proud to be a Datanaut!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
20 | |
13 | |
10 | |
9 | |
7 |
User | Count |
---|---|
39 | |
27 | |
16 | |
15 | |
10 |