Show data with the month of a filtered week

[andreazambon]

Hi there. 

Second question of the day... 

I need to filter a week, for example WK49, and in a view I need to see data with the month of the filtered week. 

In this case, If I choose WK49, I need to see the whole data with month = December. 

Possible?

Still, I don't know how to manage cases as WK48, which is both in November and December. I have to ask informations to my colleagues 😛

Thanks

[v-stephen-msft]

Hi @andreazambon ,

Here's my solution.

Sample data

Steps:

You can create a calendar with the week numbers. The [sort] column is to sort the [WeekNum] column.

Calendar = ADDCOLUMNS(CALENDAR(DATE(2022,1,1),DATE(2022,12,31)),"WeekNum","W"&WEEKNUM([Date],2),"sort",WEEKNUM([Date],2))

The relationship is as follows.

The week number column of the slicer comes from the calendar table, the main table is the date and value, and when you filter W49, the 49th week of November and December is displayed.

You can check more details from my attachment.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[andreazambon]

Thanks for your answer. 

I need to see the total data from the month. Suppose to have a 

Date	Week	Value
06/11/2022	49	100
12/12/2022	50	150
25/11/2022	47	300

Suppose to choose the WK 49. 

I need to see "December" and value = 250.