Calendar: Get the last date after filter

[ryan0521]

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 Periodical'[Date]))" 

However, what I want is, If I filter the dates using slicer from the Main table, the new table should refresh too.

Example:

Main Table

Item	date
1	1-Jan
2	1-Feb
3	1-Mar
4	1-Apr
5	1-May
6	1-Jun
7	1-Jul
8	1-Aug
9	1-Sep

New Table

Date

1-Jan

2-Jan

3-Jan

4-Jan

5-Jan

6-Jan

7-Jan

8-Jan

until December 31

If I filter Main table from the Report, NOT IN THE TABLE, I want that the New table will refresh.

Main Table filtered until March

Item	date
1	1-Jan
2	1-Feb
3	1-Mar

New Table 

Date

1-Jan

2-Jan

3-Jan

4-Jan

5-Jan

6-Jan

7-Jan

8-Jan

until March 31

Hope you can help me, I've been looking for this one for almost 1 week LOL. 

[Anonymous]

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

[ryan0521]

@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.