Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.