Forum Discussion

ryan0521's avatar
ryan0521
Frequent Visitor
7 years ago

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 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
Itemdate
11-Jan
21-Feb
31-Mar
41-Apr
51-May
61-Jun
71-Jul
81-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

Itemdate
11-Jan
21-Feb
31-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. 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      ryan0521
      Frequent Visitor
      7 years ago

      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.