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?
