Adding days

[gaikwadaa123]

Hello my data looks like below:

 I have calculated the Date Window column by using date diff function between Date and today column. It is basically the number of days between two dates.

I want add another column where it will capture 0 to 7 days from date window and will be named as day+7 

same like 0 to 14 and it will be named as day+14 and 0 to 21 as day+21. 

and I will use day+7,day+14 on slicer.  so that it will select the date from day+7 so on..

For that in my new column I am expecting 

Date window    slicer

0                        day+7

1                        day+7

2                        day+7

3                        day+7

4                        day+7

5                         day+7

6                        day+7 

7                        day+7

Basically I am trying select 0 to 7 days on visulazation pane by just selectiong today+7 days on slicer 

Thank you in adavnce

[rfigtree · Accepted solution]

If you divide datewindow by 7, use the round up function then use convert function to turn it into a string then append "day + " to the front you will get what you want.