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:
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
I just used the logic in your file and figured out a solution for my problem. I just created a month index and modified the logic from your solution. I'm very new to all of this so Thank you so much for all the help. Really appreciate it! Also, my apologies for not sharing enough details earlier.