I am still busy with enhancing the model that I have shown you before. The following:
In all of the tables being used there are two columns: Time_period_start and Time_period_end.
There are measures that are calculating the first date when the data appears and a measure for the last date the data appears.
These dates are based on country level and a franchises within that countries.
When I want to do this in SQL server it would be something like a group by function on the countries and franchises.
Question : When I remove both columns for time_period_strat and time_period_end. I add a column with the dateKey and having a measure table for calculating the first and the last day per country and franchise.
Latest Sales Date =
When I have this measure it needs to be based on country and franchise. I need some kind of filter ?
Can you point me in the right direction please.