Forum Discussion

kcjeongzz's avatar
kcjeongzz
New Member
8 years ago

If a date is between start and end date

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...
drewlewis15's avatar
drewlewis15
Icon for Solution Specialist rankSolution Specialist
8 years ago

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's avatar
kcjeongzz
New Member
8 years ago

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's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    Share some data and show the expected result there.