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: https://curbal.com/blog/glossary/grou...

Additional resources:
SELECTEDCOLUMNS:    • DAX Fridays! #58: COMBINEVALUES  
SUMX:    • DAX Fridays! #3: SUM and SUMX  
Variables::DAX Fridays! #11:    • DAX Fridays! #11: Using variables in DAX  
SUMMARIZE: DAX Fridays! #14:    • DAX Fridays! #14: SUMMARIZE  

Get Northwind Dataset:    • Northwind data source: A great online sour...  

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



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

SUBSCRIBE to learn more about Power and Excel BI!
   / @curbalen  

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

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

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



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


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

#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP