I will like to seek you advise on how to build the relationship on data model. I have a customer count table as follow:-
Store code Store name Weekname Customer Count WeekofYear Year
101 ABC 4 Jan 2017 1000 1 2017
Customers count in the table above are by store, by week and weekly count from year 2017 to Mar 21, 2018.
I have another date table which I used the date table quote as published in Enterprise DNA.
I have issue on building the relationship between these 2 table as there is no unique identifier in the data table. Please advise how I should link up these 2 tables.
Please also advise on the measures for YTD & LY YTD customer count.