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

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.

Thank you so much for this share.

Thank you so much

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?

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.

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.

Thank you so muuuuuuch!

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

great video, as always

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!

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

You truly are the best! Made it so simple.

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

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

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!

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.

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?

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

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

Great Content!

Great video as usual. Learnt something new

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

Thanks!!! Justo lo que buscaba :)

It is friday, yay! 🥳

Very useful!!! TOP Ruth!! 🤙🏻🤙🏻🤙🏻

Great video...thanks.

Thanks Ruth! Happy Friday!

Thank you !