start of week date key

[Anonymous]

I have built a date key in order to get start of week dates for my data:

DateKey = CALENDAR(DATE(2000,01,01),DATE(2050,12,31))

then

WeekStartDate = DateKey[Date]- WEEKDAY(DateKey[Date],2)+1 // Monday as Week start date

However I keep arriving at a many to many relationship when I try to RELATE the DateKey to my Core Data table.

Is there any way to create a DateKey with just start of the week dates (and index)

NOTE: I cant manually enter the start of the week data and RELATE based on that.

Can anyone help?

[amitchandak]

@Anonymous , case your table has the start of week date. You need to join it with the date key.

Start of Week in Date table will make sure a similar display in visual.

If not share what is there on the fact side. I shall try suggest the join

[Anonymous]

The only way I can t get it to work is using the single date variable:

[Anonymous]

However I would like to use SoW (START OF WEEK) and WeekStartDate relationship

except having a 1 to many relationship and not many to many