Forum Discussion
View set by another reader
newgirl , The information you have provided is not making the problem clear to me. Can you please explain with an example?
But What I am getting, you need 2 things, A week setup from Thursday to Wednesday and Select this week by default
This should help for week start of your choice
Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
Default week :https://www.youtube.com/watch?v=hfn05preQYA
Select this week in the slicer
Week Type = Switch( True(),
[start week]<=Today() && [end date]>=Today(),"This Week" ,
[start week]<=Today()-7 && [end date]>=Today()-7,"Last Week" ,
[Week Name]
)
Appreciate your Kudos.
Hi amitchandak !
Here's the scenario:
The report has a calendar slicer (From and To date slicer) and is scheduled for daily refresh. The point person appends the new data in SharePoint and waits for the scheduled refresh to pass by (in short, I am already hands off when updating their report). Then she opens the report and filters the slicer as of reporting period, say, January 5 to January 10, 2020 to see if the data she uploaded is reflected correctly in the report (basically, she's the one who's in charge of the report and checks it).
What they want is that after she checks the data, when other members would open the report, they would also like to see January 5 to January 10, 2020 set as the date, just like how she filtered it. This is where my problem comes in.
As much as I want to use a measure using a "Today" or "This Week" in the slicer, I can't because of 2 reasons:
- They want the 'From and To' date slicer to stay because at any time, they would like to view the past data for a specific period (example Jan 1 to Jan 13 or Jan 15 to Jan 18 or Dec 10 to Jan 10)
- The weekly period they are using now could change any time as well. For example, last year, the reporting period was Tuesday of the last week until Monday of this week. This year, it has changed again. In the future, it could also change. In short, the reporting period is not really constant.
newgirl , Based on what I got.
As of now, you can not initializes date ranges based on some logic.
She can save the report and share with other users again, ( publish and share)
other option is
Create a Tuesday Week( Blog Given) in date table, Create this week in date table and select that(Video shared).
In this week you can create WTD ( Week till date if needed)