Forum Discussion
Solved
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 s...
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)
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)
I can't seem to call the Created column in the Measure formula it says that it does not exist.