Adding days

gaikwadaa123 — Wed, 19 May 2021 18:41:12 GMT

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

Re: Adding days

rfigtree — Wed, 19 May 2021 21:34:58 GMT

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.

topic Adding days in DAX Commands and Tips

Adding days

Re: Adding days