Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |