Forum Discussion
Calendar: Get the last date after filter
Hello Geniuses, I have 1 Main table with a "Date" column, then I made a new table with this formula " Rolling periods = CALENDAR (FIRSTDATE('Income Periodical'[Date]),LASTDATE('Income Periodica...
Hello Ryan,
Unfortunately, the outcome you are looking for is not possible that way. The tables are created before slicers are read and measures are calculated.
Have you tried creating a relationship between 'Income Periodical'[Date] -> 'Rolling periods'[Date] and using 'Rolling periods'[Date] in the slicer to achieve the result you are looking for?
Kind regards,
Alex
Anonymous yes, but what I need is, I have a rolling 13 months and after I filter the dates the rolling months doesn't move.