Week Number Date Format

[RLSid17]

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.

[amitchandak · Accepted solution]

@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]

I managed to create a calculated column in the Table but this was the result:

The formula is not following the date format of the Created column which is D/M/YYYY instead it follows M/D/YYYY.

[RLSid17]

I can't seem to call the Created column in the Measure formula it says that it does not exist.