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?
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.
|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|
Solved! Go to Solution.
@PBI_newuser I would try this approach:
1. Create a table with the Last X Days mapped to your Days Difference (Modeling > New Table)
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.