Calculating Dynamic % Of Total Changes - Power BI Analysis w/DAX - YouTube
Recently on the EDNA support forum, a member was stuck on how to work out the differences around percent of total calculations year to year.
There's a much simpler and dynamic way this can be done.
In this tutorial, I run through the techniques required to make this all work in Power BI.
It's much simpler than you think.
***** Video Details *****
1:56 - calculating percent of total revenue
3:57 - calculating dynamic change between years
***** 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 - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download/
FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://www.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
How To Create A Dynamic Power BI Report - https://blog.enterprisedna.co/create-an-entirely-dynamic-report-in-power-bi/
Calculating Percent Profit Margins Using DAX In Power BI - https://blog.enterprisedna.co/how-to-calculate-profit-margins-in-power-bi-wdax/
Analyze Profit Margin Changes Overtime – Analytics With Power BI And DAX - https://blog.enterprisedna.co/analyze-margin-changes-overtime-analytics-with-power-bi-and-dax/
***** Related Course Modules *****
Advanced DAX Combinations - http://portal.enterprisedna.co/p/advanced-dax-combinations
Time Intelligence Calculations - http://portal.enterprisedna.co/p/time-intelligence-calculations
Power BI Super Users Workshop - http://portal.enterprisedna.co/p/powerbisuperuserworkshop
***** Related Support Forum Posts *****
Calculating Percentage Change And Want To Hide Current Year - https://forum.enterprisedna.co/t/calculating-percentage-change-and-want-to-hide-current-year/1539
Percent Change By Year And Month - https://forum.enterprisedna.co/t/percent-change-by-year-and-month/307
Percentage Of Target Diff Calculation - https://forum.enterprisedna.co/t/percentage-of-target-diff-calculation/3546
For more percent of total change support queries to review see here…. - https://forum.enterprisedna.co/search?q=percent%20of%20total%20change