Forum Discussion
Helper IDATEADD not giving me the dates
I am needing to create a visit window report to show the expected visit windows for visits based on the procedure date.
here is what i have uploaded as an example:
I am trying to have the [Visit window Start] column display to show the [Procedure] date plus 5 days. (see formula bar for what i used).
So for example, the first procedure date is listed as 01-MAR-2020 so the date that should be calculated is 06-MAR-2020. But nothing shows up.
What am I doing incorrectly?
guanel1 ,
You need a table with continuos date, create a date table and relate them, use this code on your column:
Column = DATEADD(Data[Date], 5, DAY)
3 Replies
camargos88Community Champion
guanel1 ,
You need a table with continuos date, create a date table and relate them, use this code on your column:
Column = DATEADD(Data[Date], 5, DAY)- amitchandak
Super User
guanel1 , date add need continuous dates , Simply add +5 for days
Visit Window Start = Table3[Procedure] +5
Also, refer: https://www.youtube.com/watch?v=YWo-ZpKM6gU
- guanel1
Thank you, this is works when there is always a date listed in the procedure column. However, if it is blank, what formula should i use to have it give me a blank answer?
