adding dates

[salman_ali]

Hello,

if date is 7 days ago, I would like to add 7 days to today's date

if date is 6 days ago, I would like to add 6 days to today's date

so on and so forth

if date is today, then leave it as is 

otherwise blank 

but my formula doesn't work, 

it gives me blanks or today's date 

reasons?

[V-lianl-msft · Accepted solution]

Hi @salman_ali ,

Refer to this:

next_date = var diff = DATEDIFF('Table'[date],TODAY(),DAY)
return IF(diff>=0&&diff<=7,TODAY()+diff,BLANK())

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@salman_ali , Seem like a new column like

Switch( True() ,
Query[Event Date] >= today() -7 && Query[Event Date] <=today() , today(),
blank()
)