DAX Fridays #203: Examples of MAX calculations of groups and subgroups

I publish two DAX Fridays! videos ago a video on how to calculate the MAX of a measure and you had more questions about max calculations, so lets do some more MAX exercises here.

MAX of a measure:


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[supersayan]

OMG! I never watched a video of DAX with a smile on my face. Your positivity is really contagious.
The way you explain it, is soo easy and simple to digest.

I really hope that one day you give a (online ) live training.
Keep up the good stuff!

[jaanaan]

that's very good that you are using a simple example but solving a very big problem for us. Thanks again, your videos are very helpful.

Great and clear example as always, Ruth, thank you!! 😃👍🏻

[mariabeatrizugalde]

Muchas gracias Ruth, una vez más me ayudaste a salir de un enredo. Me encanta que tus videos sean cortos pero perfectamente bien explicados. Muchas gracias!

[margotkk]

Very well explained. Love your tutorials. Thanks for posting!

[darlenesoukhaphonh]

You truly are the best! Made it so simple.

[KILARINAGARAJU]

love you.. so many problems solved with help of your videos .. thank you so much

[pragmatistglobalanalyticsa]

Great video as usual. Learnt something new

[Marquinhos_]

Hello, is it posible to get the max value by more than one column, I mean, I have a table with mains columns, Country, Segment and Month, so I want to get in the max value with this 3 columns. Thanks in advance.

[robinmauldin]

Thank you for your videos. They are very helpful. How would I get the max value of transactions for each store within a customer. For example, Max transactions for store a, customer A; store b, customer A.

[robertuskoko]

Thanks ruth
How to calculate how many transaction by month in every store in a year, so i can get result how many store by the number transaction by month

[nuffzed]

hi, is there a way to do a count for max occurences ?
eg store a is the most amount of stores (the answer is 5) - how do you do a count and total?

[Optimistic_Pessimist]

What if you need to take the max of 3 columns and only if the number=the number. I’ve been struggling with this today.

[tj]

Thanks for the video. Quite informative. What is the opposite of "All Except". I have a large table with 30 columns. Using "All Except" means I have to list about 25 fields. I need a formula that says "Exclude All except" ...something like that.

[djmenon]

Awesome video! can you create a video that will show how to do this week, last week, count as on today, this month, last month, week over week comparisons? or can you share a pbix file that already has that?

[malkapauramnarendra]

instead of customer can you use dates and create the MAX date count of transactions and min date of transactions given the table?

[khadarbasha]

HI....
i am trying to get the same store same product with
different rates variation like below data but no luck.

[adilumr]

This doesn't work if we ae going to take max of a date column by store

[raghavendrams]

How to find a max of trans id per store and customer
Customer Store TransID
A a 3
A b 2
B a 2
B b 1