Forum Discussion
Post PartisanYYYYWW in weekly table
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?
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 !
1 Reply
- serpiva64
Solution Sage
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 !