How To Create Unique Subtotals In Power BI Tables Using DAX

I wanted to show you in this tutorial how to create unique subtotals with Power BI. This actually isn't possible if you use just the out of the box table visual in Power BI. You need to use a combination of technique developed and refined by Enterprise DNA. This is a seriously cool technique that opens up plenty of new visual possibilities in Power BI. Enjoy learning about this one. Sam ***** Video Details ***** 2:14 - creating a template in Excel 3:59 - formula for Revenue 4:14 - formula for COGS 4:27 - formula for gross profit 4:55 - SWITCH TRUE logic ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download/ Enterprise DNA Membership - https://enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/ ***** Related Links ***** Power BI Financial Reporting: Allocating Results To Templates At Every Single Row - https://blog.enterprisedna.co/how-to-allocate-results-to-templates-at-every-single-row-using-power-bi/ Power BI Financial Reporting Tips And Techniques For Accounting & Finance - https://blog.enterprisedna.co/power-bi-financial-reporting-tips-and-techniques-for-accounting-finance/ Power BI Reporting Templates Expanded – Power BI Visualization Concepts - https://blog.enterprisedna.co/power-bi-reporting-templates-expanded-power-bi-visualization-concepts/ ***** Related Course Modules ***** Financial Reporting W/ Power BI - https://portal.enterprisedna.co/p/financial-reporting-power-bi Scenario Method Workshops - https://portal.enterprisedna.co/p/scenario-method-workshops DAX Formula Deep Dives - https://portal.enterprisedna.co/p/dax-formula-deep-dives ***** Related Support Forum Posts ***** Financial Reporting In Power BI - Custom Subtotals - https://forum.enterprisedna.co/t/financial-reporting-in-powerbi-custom-subtotals/780 Finance Template And Dozens Of Subtotals And Totals - https://forum.enterprisedna.co/t/finance-template-and-dozens-of-subtotals-and-totals/3870 DAX For Dynamic Subtotals & Grand Total - https://forum.enterprisedna.co/t/dax-for-dynamic-subtotals-grand-total/5532 For more subtotal support queries to review see here…. - https://forum.enterprisedna.co/search?q=subtotal

Видео How To Create Unique Subtotals In Power BI Tables Using DAX автора Программирование Профессионал