30, 60, 90 day filter

[KGuyton]

I am trying to create a measure that will slice a date by 30, 60, and 90 days from current day.  I have an expiration date column and I am trying to create a slicer that lets me show accounts that will be expiring in the next 30, 60, and 90 days from the current day.  Any ideas?

[Greg_Deckler]

If the data is updated everyday the simplest method is to create a calculated column that contains the designation 30, 60, 90 days. Then you can use this calculated column in a slicer.

If you are in the situation where you need this to be 100% dynamic, then you need to use the Disconnected Table Trick. As this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...

[KGuyton]

I am not sure how to create such a table.

update:  I went ahead and created a new table with a period that I was able to add a relationship to my existing calendar using this code: 

DatePeriod =

UNION (

ADDCOLUMNS( SUMMARIZE( CALCULATETABLE('Date' , DATESBETWEEN('Date'[Date],today(),today()+30) ), 'Date'[Date]),"Period","Next 30 Days") ,

ADDCOLUMNS( SUMMARIZE( CALCULATETABLE('Date' , DATESBETWEEN('Date'[Date],today(),today()+60) ), 'Date'[Date]),"Period","Next 60 Days") ,

ADDCOLUMNS( SUMMARIZE( CALCULATETABLE('Date' , DATESBETWEEN('Date'[Date],today(),today()+90) ), 'Date'[Date]),"Period","Next 90 Days") )

[v-lili6-msft · Accepted solution]

HI, @KGuyton 

You could try this way as below:

Step1:

Add a simple table that only contains 30,60,90 value for slicer.

For example:

In the example, I use a simple data sample

Step2:

Then add this conditional in your formula

Measure = CALCULATE(SUM('Table'[Value]),
FILTER('Table','Table'[Date]<=TODAY()+SELECTEDVALUE(Days[Days after],MAX(Days[Days after]))))

Result:

here is sample pbix file, please try it.

Best Regards,

Lin