Forum Discussion
If a date is between start and end date
Solution SpecialistYou 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:
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/
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
Super User
Hi,
Share some data and show the expected result there.
