Time dimension formula

Options
CommunityMember125342
CommunityMember125342 Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Source Module has Year, Target module has Months.

Source - Time dimension (YEAR), Cost center dimension, Line Item

Target - Time dimension (Months), Cost Center dimension, Line item

 

Source has rate by year, for example for FY23,

Want to bring FY23 rates to all the months in target module. What formula would i use in terms of time.

Tagged:

Categories