Forum Discussion
Solved
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 lo...
Ashish_Mathur
Super User
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
- Ashish_Mathur
Hi,
I can only understand the answer of point a. I cannot understand the expected answer of b, c and d. GIven an explanation.
- Ashish_Mathur
You are welcome.
