Dax Fridays 77 Groupby Currentgroup

In today's DAX Fridays, we will go through the DAX function GROUPBY with an example.

GROUPBY is similar as SUMMARIZE, but the difference is that in the expression part, you use DAX iterators to get your results.
You can also nest GROUPBY functions to get for example the highest sales amount by country.

Link to pbix file: curbal.com/blog/glossary/groupby-dax-example

Additional resources:
SELECTEDCOLUMNS: youtube.com/watch?v=e8lzj9F7aQg
SUMX: youtube.com/watch?v=vcYz0XPklXg
Variables::DAX Fridays! #11: youtube.com/watch?v=kaPNxB-Hkvw
SUMMARIZE: DAX Fridays! #14: youtube.com/watch?v=-Ola264bKXk

Get Northwind Dataset: youtube.com/watch?v=k3NMIlLffrU

Link to DAX Fridays survey: bit.ly/2MMM4KK

Looking for a download file? Go to our Download Center: curbal.com/donwload-center

SUBSCRIBE to learn more about Power and Excel BI!
youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l

ABOUT CURBAL:
Website: curbal.com
Contact us: curbal.com/contact

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

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

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB

#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP

Author

Ariyani

Como educador, estou profundamente engajado no desenvolvimento dos estudantes em ambiente escolar, adotando métodos pedagógicos que valorizam conexões genuínas e são movidos por inovação e fervor. É minha vocação guiar os alunos na jornada de se tornarem uma geração notável, empregando estratégias de ensino amplamente aclamadas por prestigiadas instituições acadêmicas ao redor do globo - preview.pbjmanagement.co.uk