Hi everyone,
I am currently comparing three years of daily transaction level data for retail stores across NZ. I want to introduce a new measure into the data model/PowerPivot regarding the date that the retail store was refitted.
i.e. did the transaction date take place before the refit or after. Ideally I would then like to add a measure/comparison for 12 months before and then 12 months after refit date.
The two tables have a relationship created on store name.
I am not sure where to start on this formula
Table One - Store Name, refit date
Table two - Store name, date, visitors, margin, units etc
Appreciate any help that can be offered.
Hi Amber,
Add your calculated column to Table two. This is your fact table with the transactions. You need to classify each transaction into when it was refitted. You can only do this in Table two.
It's also possible, depending on how you want to report on this data, to create a measure, as opposed to a calculated column, but it's too difficult to say without much more information.
If your model isn't millions of rows big, then try the calculated column. This will be easiest for you to write.
Mynda
