Forum Discussion

danb's avatar
danb
Resolver I
6 years ago
Solved

Filtering Table based on Valid After and Valid Before dates

Good morning experts!

I should probably be able to figure this out however I am hitting a wall. I have a base table pricing catalog guide. It lists out all of the different items that we are selling, the price and the validity dates. The table goes back several years as well as into the future. What I would like to do is be able to have a slicer or two called "Valid After Date" and "Valid Before Date" that a user would be able to put dates into and see all of the items in the pricing catalog that have active pricing between (and including) those dates. 

 

In order to better explain I made a very simple example of what I am trying to do. 

Here is my base table:

Here are the two slicers:

 

This would be the end result that I would want based on the slicers.

 

 

Here is the table so you can copy it.

Base Table
ItemPricePrice Start DatePrice End Date
Apples $  1.981/1/20201/31/2020
Bananas $  0.883/1/20203/18/2020
Peaches $  0.5612/1/20193/31/2020
Apples $  2.022/1/20202/29/2020
Blueberries $  5.992/10/20203/5/2020
Strawberries $  4.651/15/20202/2/2020

 

 

Thanks,

Dan

2 Replies