I have a column in one table representing Monthly Customer Spend. A relationship exists between this table and a DateKey Table.
All of this is represented in a "Matrix" style table, which neatly shows me customer spend in each period of time. Month, Quarter, Year, etc.
I would like to understand the difference in ustomer spend, between the two (or more) periods of time.
I am looking to understand the difference in spend, between two periods of time to determine whether a customer is increasing, decreasing spend between the periods of time.
All help is appreciated.
The good news is that you will be able to build your matrix with all the measures you mention.
It will be much easier for us to provide help in the form of calculated measures etc, if you can provide some small samples of your data.
Once again @Phil_Seamark to the resuce! Thanks.
The link below will take you to a sample dataset. Please keep in mind that this is joined with a datekey table. (Not the time-based columns in the sample data.)
Please advise on the recommended calculated measures.
The end goal is to show the difference between 2 ore more periods of time. Month vs. Month, Qtr vs. Qtr, Year vs. Year.