Comparing Actual vs Budget vs Last Year Results in Power BI w/DAX


Use this great technique to visualise how you are performing versus budgets and last years results. View the information cumulatively for added impact. Plenty of ideas to work through during this tutorial including; cumulative totals, time intelligence, using variable, commenting in DAX code and much more.

***** Video Details *****
2:25 – total sales
2:46 – budget allocation per day
3:56 – total sales last year
4:30 – cumulative sales
5:31 – cumulative sales last year
5:43 – cumulative budgets
5:58 – visualisation

***** 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 – https://enterprisedna.co/power-bi-resources
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 *****
Compare Cumulative Information Over Different Months In Power BI – https://blog.enterprisedna.co/2019/10/10/compare-cumulative-results-for-multiple-months/
Allocate Monthly Forecasts Across Daily Results In Power BI Using DAX – https://blog.enterprisedna.co/2019/07/10/allocating-detailed-monthly-budgets-or-forecasts-in-power-bi-using-dax/
Measure Branching – The Most Important Concept When Using DAX In Power BI – https://blog.enterprisedna.co/2018/08/01/what-is-measure-branching/

***** Related Course Modules *****
Solving Analytical Scenarios w/Power BI & DAX – http://portal.enterprisedna.co/p/solving-business-scenarios-with-power-bi-and-dax
Advanced Data Transformations & Modeling – http://portal.enterprisedna.co/p/advanced-data-transformation-and-modeling
Advanced Analytics in Power BI – http://portal.enterprisedna.co/p/advanced-analytics

***** Related Support Forum Posts *****
Cumulative Budget Question – https://forum.enterprisedna.co/t/cumulative-budget-question/2040
Cumulative Total With A Branched Measure That Utilises TREATAS – https://forum.enterprisedna.co/t/cumulative-total-with-a-measure-branched-measure-that-utilises-treatas/4336
Cumulative Budget – New Month – https://forum.enterprisedna.co/t/cumulative-budget-new-month/735
For more cumulative budget support queries to review see here…. – https://forum.enterprisedna.co/search?q=cumulative%20budget