Forum Discussion
Adding days
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
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.
1 Reply
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.