YYYYWW in weekly table

[koorosh]

Hello All,
There are two tables with the following columns.

Date table : Date_id (integer yyyymmdd), date (Date), month (integer, yyyymm), week (integer, yyyyww), Year (integer)

Weekly_Retunrs table: week_id (integer,yyyyww) , total returns (Floating)

How can create a new calculated column named Date_id in the Weekly_Retuns table to use it to make a relationship to the Date table for creating a weekly returns visual?

[serpiva64 · Accepted solution]

Hi,

have you tried to create the ralationship directly between week in datetable and week_id in Weekly_returns.

I think it function.

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !