How to include last 30 days data in last 60 days category

[PBI_newuser]

Hi,

I have a table as shown below.

How to create a field to show Last 30 days, Last 60 days, Last 90 days and Last 180 days data?

Example:

When user selects "Last 90 days", Job A-123, B-123, C-123 should show up.

When user selects "Last 60 days", Job A-123, B-123 should show up.

When user selects "Last 30 days", Job A-123 should show up.

Job	Days Difference	Category
A-123	25	0 - 30 days
B-123	38	31- 60 days
C-123	86	61- 90 days
D-123	130	91 -180 days
E-123	157	91 -180 days
F-123	190	> 180 days

[DataZoe]

@PBI_newuser I would try this approach:

1. Create a table with the Last X Days mapped to your Days Difference (Modeling > New Table)

Last X Days Slicer =

union(

ADDCOLUMNS(GENERATESERIES(1,30),"Last X Days","Last 30 Days"),

ADDCOLUMNS(GENERATESERIES(1,60),"Last X Days","Last 60 Days"),

ADDCOLUMNS(GENERATESERIES(1,90),"Last X Days","Last 90 Days"),

ADDCOLUMNS(GENERATESERIES(1,max('Table'[Days Difference])),"Last X Days","All Days"))

2. Then create a relationship between your Table and this new table on the common Days Difference column. This will need to be many to many, the direction has to be that Last X Days Slicer filters Table.

3. Now you can use your Last X Days field as a slicer to have the jobs filter appropriately. 

[PBI_newuser]

Hi @DataZoe , thanks for the solution. But it doesn't work for my data.
Here is the sample. Could you please take a look at it?

[DataZoe · Accepted solution]

@PBI_newuser Looks like you had just missed the relationship between the tables step:

Once that was in place, it worked. Please see attached.

[PBI_newuser]

Thanks @DataZoe! It works!

[DataZoe]

@PBI_newuser Awesome, glad to hear it! 🙂