Forum Discussion
Week Number Date Format
Hi,
Is there a way to format the Week Numbers to Month and Date?
For example, I have 2 slicers which would be Month and Week.
When I select the Month slicer to November, then in the Week slicer it would show the following:
Nov. 7
Nov. 14
Nov. 21
Nov. 28
So it's like showing the start of the week. Currently, I have the slicer for Week Number. I need to be able to show the above results for easy filtering to end users.
I guess the Month doesn't matter as long as it shows the start of the week depending on the date. Also, the Date column comes from multiple datasets so I used the UNION function to gather those into one table.
RLSid17 , You can use the week start/end date
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
3 Replies
RLSid17 , You can use the week start/end date
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
