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!
+12- Master Helper
- Answer
This formula may work for you.
Week.'Start Date'[Week.'Last Actual Week'][remove firstnonblank:Week]+7
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.