SCD1 and power pivot

The filter context date is for any time series report.  For example, if I want to show the growth in customers by geography, over time and accomodate the fact that customers move from one state to another.  For example, I moved to California from NY in 2016.  If I was a customer, with scd data, I'd count as a customer in NY in 2014 and California today.  If instead, I used flat data with today's customer dimension against the dates, I'd be a customer in California in 2014 and today.  This is even more importnat for things like sales pipeline maturation or account manager vs revenue growth over time.  Again the critical components is that it's over time and that the dimensions are changing