Hi!
Can you please help setting up the formula to populate the current forecast week?
I already have a Week dimension and the metric should populate 2025-06-08 as of today because 2025-06-01 is marked as “Last Actual Week”.
Thanks!
Page 1 / 1
This formula may work for you.
Week.'Start Date'tWeek.'Last Actual Week']kremove firstnonblank:Week]+7
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.