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 - portal.enterpri...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterpri...
FREE - Power BI Resources - enterprisedna.c...
FREE - 60 Page DAX Reference Guide Download - enterprisedna....
Enterprise DNA Membership - enterprisedna....
Enterprise DNA Online - portal.enterpri...
Enterprise DNA Events - enterprisedna....
**** Related Links ****
Power BI Financial Reporting: Allocating Results To Templates At Every Single Row - blog.enterpris...
Power BI Financial Reporting Tips And Techniques For Accounting & Finance - blog.enterpris...
Power BI Reporting Templates Expanded - Power BI Visualization Concepts - blog.enterpris...
**** Related Course Modules ****
Financial Reporting W/ Power BI - portal.enterpr...
Scenario Method Workshops - portal.enterpr...
DAX Formula Deep Dives - portal.enterpr...
**** Related Support Forum Posts ****
Financial Reporting In Power BI - Custom Subtotals - forum.enterpri...
Finance Template And Dozens Of Subtotals And Totals - forum.enterpri...
DAX For Dynamic Subtotals & Grand Total - forum.enterpri...
For more subtotal support queries to review see here…. - forum.enterpri...
Негізгі бет How To Create Unique Subtotals In Power BI Tables Using DAX
No video
Пікірлер: 71