cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ryan0521 Frequent Visitor
Frequent Visitor

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. 

2 REPLIES 2
alexobee Frequent Visitor
Frequent Visitor

Re: Calendar: Get the last date after filter

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 Frequent Visitor
Frequent Visitor

Re: Calendar: Get the last date after filter

@alexobee  yes, but what I need is, I have a rolling 13 months and after I filter the dates the rolling months doesn't move.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 224 members 2,257 guests
Please welcome our newest community members: