Cannot find table while creating a measure using a Table defined withing measure context
In bellow image, dates_reference is my global dates table. This code snipped allos to add a number of working (non weekend, non holiday) days to any given date (here initial dates is [_plan_test_end_date] and days to add is the output of a variable segmentation tied to a manual table _more_days[_more_days_value]). Steps are: 1. FIlter general dates table (which is big) for the time starting from the date u wanna work with, excluding non working days. 2. Calculate how many days (rows) are beween a row and all previous rows as an offset. 3. See for which date, the offset match teh working days needed. Crude, but works in tehory. Yet, I define all the "filtered" date tables within the measure, FilteredWorkingDaysTable seems to be created properly (no error), but is not visible in the context of second WorkingDaysTable, seems is not "visible" for using its atributes as filter condition. Copilot did not helped. Any clue?
Determining the Completion Date Based on the Start Date + <xx> Working Days
Hi, I am currently working with two specific tables: a Fact Table and a Calendar Table. My objective is to accurately calculate the completion date for each entry. The formula to determine the completion date is: Start Date + Number of Working Days. Fact Table Calender Table For example, if the start date is 2017/01/01(1st Jan 2017), then the completion date should be 2017/01/06. Similarly, for a start date of 2017/01/02, the completion date should be 2017/01/09 I seek guidance on how to implement this calculation effectively. Any assistance or advice you can provide would be greatly appreciated. Thank you for your support. Best, Rosh
