If a date is between start and end date

[kcjeongzz]

Hello,

My company has hundreds of items and all have different launch dates. The item is considered as "new" item during the first 6 months, after that, it is considered as "old" item. (ex. if an item is a launch on January 15th, it is a new item until July 15th) I trying to do this with date function and conditional column but I kinda stuck now. Any help, please?

Thank you 

[drewlewis15]

You could add a calculated column with the following statement (replace the text in green with your table[field]:

Status = IF('Product'[Launch Date] > EDATE(TODAY(),-6), "NEW", "OLD")

It would give you something like this:

[kcjeongzz]

I have one more question.

when I use the date slicer, lots of products are not shown in the table..

help please TT

[drewlewis15]

Have you created a calendar table to relate your product table to?  If not, you need to create a dynamic calendar table to account for each day and then relate this table to your calendar table.  Then, use the date from your calendar table as your slicer.  See the post below about creating a dynamic calendar table if you need help with that:

https://www.powerquery.training/portfolio/dynamic-calendar-table/

[kcjeongzz]

I've already created a calendar table and made a connection between them. 

Let's say I select August 2017 on date slicer. I want my table show product I~N as "NEW" and H ~ G as "OLD" and O~T as "Not launched yet". I know it is kinda complicated. should i change the formula for this ?

sorry for poor explanation though..

Thank you !

[Ashish_Mathur]

Hi,

Share some data and show the expected result there.

[kcjeongzz]

Hello,

My company has hundreds of items and all have different launch dates. First six month, items are considered as "new" item, but after 6 months it is "old" time. For example, if it is launched on January 15th, it is a new item until July 15th. I've tried to use date function and a conditional column for this but I kinda stuck now. I do not even know how to start this. any help, please?

Thank you