Forum Discussion
Dynamically change state based on date slicer - help required
Hi All,
I have a table that looks like this:
| Location | Start Date |
| loc 1 | 1-Jan-19 |
| loc 2 | 13-Feb-19 |
| loc 3 | 17-Feb-19 |
| loc 4 | 1-Aug-18 |
| loc 5 | 1-Jun-19 |
| loc 6 | 13-May-19 |
| loc 7 | 12-Apr-19 |
This table has a one to many relationship with my main data (DATA) table that contains an order date. This DATA table also has a many to one relationship with a date table that i created. I would need your help with the following:
I need to add a state to each of these locations based on the date selected using a slicer/filter. The expected output for Feb 2019, May 2019 and June 2019 could be as follows:
| Location | Feb State | May State | June State |
| loc 1 | Old | Old | Old |
| loc 2 | New | Old | Old |
| loc 3 | New | Old | Old |
| loc 4 | Old | Old | Old |
| loc 5 | Not launched | Not launched | New |
| loc 6 | Not launched | New | Old |
| loc 7 | Not launched | Old | Old |
Any help would truly be appreciated.
9 Replies
- Ashish_Mathur
Super User
- You are a saviour! I can’t thank you enough for this Ashish. Thanks a lot for taking some time out to help me out
I could use some more help though Ashish. One small modifications i what i am looking for:
For example:
If the slicer was set for dates between Feb 2019 to May 2019:
a) Locations launched in June 2019 - need to be classified as Not yet launched
b) Locations launched in March and April 2019 - need to be classified as New
c) Locations launched before March 2019 - need to be classified as old
d) Locations launched in May 2019 - need to be classified as Launched this month
