I was watching the following video, and i saw something which identified something which confuses me with DAX.
In that video is the following DAX calculation
Cumulative Sales For High Margin Customers =
CALCULATE( [Profits For High Margin Customers],
Dates[Date] <= MAX( Dates[Date] ) ) )
Filter replaces the Date table (which filters the Sales table). It removes the row context e.g. 25th Feb 20 and replaces it with all dates between 12th Dec 18 and 17th Oct 20 (those currently selected). The Dates[Date] <= MAX(Dates[Date]) further filters that time horizon to 12th Dec 2018 to 25th Feb 2020.
My issue is that the Dates[Date] is for the left side are the Date in the virtual ALLSELECTED(Dates) table, whilst Max(Dates[Date]) is equal to the row context e.g. 25th Feb 20.
Therefore using Dates[Date] refers to two different things, how do I know which is which. Does it depend on whether its on the left side or right side of the <= .