Calculate Previous Weeks Sales - Advanced DAX in Power BI

If you are looking to compare data between weeks you will quickly find that the native time intelligence functions don't give you an option. In this advanced example of DAX formula, I show you how you can do it using a combination of variables, CALCULATE and FILTER.
You will learn a lot about DAX in this video. Good luck
****Video Details****
0:16 - Introduction
2:02 - The Data Set-Up
2:50 - Problem With The Calculation
5:09 - Solution To Get Weekly Sales Calculation
10:27 - Conclusion
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterpri...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterpri...
FREE - 60 Page DAX Reference Guide Download - enterprisedna....
FREE - Power BI Resources - enterprisedna.c...
Enterprise DNA Membership - enterprisedna....
Enterprise DNA Online - portal.enterpri...
Enterprise DNA Events - enterprisedna....
**** Related Links ****
Compare Time Periods With Non Standard Date Tables - DAX & Power BI
• Compare Time Periods W...
Placing Workday And Weekend Day Numbers Into The Date Table In Power BI
blog.enterpris...
Calculate Consecutive Weekday & Weekend Days In Power BI Using DAX
blog.enterpris...
**** Related Course Modules ****
Time Intelligence Calculations
portal.enterpri...
Advanced Data Transformations & Modeling
portal.enterpri...
Mastering DAX Calculations
portal.enterpri...
**** Related Support Forums ****
Getting Last Week (shift specific) Data To Display In A Table
forum.enterpri...
Same Period Last Year for Fiscal Week Nbr (weeks in sales table are non standard)
forum.enterpri...
Filter A Table By The Aggregation Of Its Self
forum.enterpri...
For more weekly sales queries to review see here…..
forum.enterpri...