When And How To Use The EARLIER Function In Power BI - DAX Concepts

In this particular tutorial I dive into one of the more advanced functions in the entire DAX language. EARLIER is a relatively difficult function to grasp. The reason for this is because it requires you to have a deep understanding of the concept of context.

Sometimes within one DAX formula you can actually have multiple contexts working away to gather what's required to find the ultimate calculated result.

Essentially EARLIER allows you to jump from one particular context to another, within a formula, to retrieve a certain value that's required for your calculation.

The best way to explain it is certainly through this video tutorial which is a lengthy one to really dive into the nuances of this particular function.

**** Video Details ****
5:08 - calculating cumulative product sales
5:49 - calculating if product index is less than or equal to 8
8:40 - creating cumulative total based on ranking
9:32 - using variables to calculate cumulative product sales

**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE - Power BI Resources - https://enterprisedna.co/power-bi-res...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

**** Related Links ****
Simple Filters w/CALCULATE – Ultimate Beginners Guide to DAX -    • Simple Filters w/CALCULATE - (1.13) U...  
How To Calculate Budget Or Forecast Results Cumulatively In Power BI - https://blog.enterprisedna.co/2018/08...
Compare Multiple Metrics Cumulatively in Power BI using DAX - https://blog.enterprisedna.co/2017/12...

**** Related Course Modules ****
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mast...
Solving Analytical Scenarios w/Power BI & DAX - http://portal.enterprisedna.co/p/solv...
Financial Reporting w/Power BI - http://portal.enterprisedna.co/p/fina...

**** Related Support Forum Posts ****
Cumulative Total Vs Cumulative Total LY - Cleaning Visual - https://forum.enterprisedna.co/t/cumu...
Cumulative Total Question - https://forum.enterprisedna.co/t/cumu...
Cumulative Total This Year vs Last - https://forum.enterprisedna.co/t/cumu...
For more cumulative total support queries to review see here…. - https://forum.enterprisedna.co/search...