This is the last video in a 6 part series on Virtual Table functions within the Power BI Desktop using DAX. In this video, Jeremiah will discuss the summarizecolumns function and how it can be used to summarize a table by specific columns, filters, add columns, and create subtotals. It's an "All in One function." However, it shouldn't be used in measure because if the external filter context comes from context transition it can't be used.

👉 Download the student files - tinyurl.com/mvwc89yj

👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Jeremiah30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5

🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:
✔️Twitter: twitter.com/PragmaticWorks
✔️Facebook: facebook.com/pragmaticworks/
✔️Instagram: instagram.com/pragmatic.w...
✔️LinkedIn: linkedin.com/company/prag...
✔️YouTube: youtube.com/pragmaticworks

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com

#PragmaticWorks #JeremiahHersey

-~-~~-~~~-~~-~-
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
youtube.com/watch?v=ENvLrYFNeqY
-~-~~-~~~-~~-~-

• SUMMARIZECOLUMNS [DAX Virtual Table Series - Ep. 6] ( Download)
• SUMMARIZECOLUMNS - DAX Guide ( Download)
• SUMMARIZE [DAX Virtual Table Series - Ep. 5] ( Download)
• summarize vs summarizecolumns | how to use summarize and summarizecolumns in DAX with examples ( Download)
• SUMMARIZE [DAX Virtual Table Series - Ep. 5] ( Download)
• DAX | Power BI | Table Manipulation | SUMMARIZE and SUMMARIZECOLUMNS Functions ( Download)
• TWO WAYS to group data in Power BI - SUMMARIZECOLUMNS, Group By // Beginners Guide to Power BI ( Download)
• BI Desktop - Fonction DAX SUMMARIZECOLUMNS() ( Download)
• Data Lineage [DAX Virtual Table Series - Ep. 4] ( Download)
• DAX ADDCOLUMNS [DAX Virtual Table Series - Ep. 2] ( Download)
• DAX ADDCOLUMNS [DAX Virtual Table Series - Ep. 2] ( Download)
• What is TREATAS DAX function and how to use it in Power BI | DAX Sundays | BI Consulting Pro 4K ( Download)
• SELECTCOLUMNS [DAX Virtual Table Series - Ep. 3] ( Download)
• DAX VALUES [DAX Virtual Table Series - Ep. 1] ( Download)
• Summarize and Summarize Columns in Power BI ( Download)