Forum Discussion
Dynamically change state based on date slicer - help required
Super User
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.
It's the way we classify locations internally. basically, each location is the location of a retail store. Any store that is less than 2 months old is classified as New internally. Could you help me figure it out in this context? I'll try to work on it by modifying the formula from your solution sheet and see if i can get this done. Anyway, thank you so much once again
- Ashish_Mathur
You are welcome.