Forum Discussion
M_SBS_6
Helper V
Helper VDate Column based on selected period
Hi, I have a date column app_date of which I need to create my next column from. What I'm trying to do in this date column is create a rolling date from today's date. If today, I want to have ...
M_SBS_6Helper V
Helper VApp_date. New_date_flag
02/11/2023. Rolling current year
01/11/2023. Rolling current year
........
20/10/2023. Rolling current year
19/10/2023. (Blank)
18/10/2023. (Blank)
Then the following day it changes and moves forward one day so the 20/10/2023 will show as (blank).
The same principle for the same date period 1 year ago. I hope that makes sense.
ryan_mayu
Super User
Super Usermaybe you can try this
New_date_flag =
if(today()-'Table'[App_date]<=14,"Rolling current year",if(EDATE(today(),-12)-'Table'[App_date]<14&&EDATE(today(),-12)-'Table'[App_date]>=0 && year('Table'[App_date])=year(today())-1,"rolling previus year")
)pls see the attachment below