null

[hashtag_pete]

Hello S, 

based on our sample with the 5 employees, I have made the following:

added to the table a column weeknum and month. I used the formular of WEEKNUM and MONTH, which is explained here:

WEEKNUM – DAX Guide

If this helps, please accept as solution and give kudos. 

Best

hashtag_pete

[Ahmedx]

1) you must create a special calendar
2) for slicing by week you should take column By WEEK
3) for slicing by months you should take column By Month

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rh2_eV9t_hUaEIWZ9?e=9cTVtf

[Anonymous]

null

[Ahmedx]

have you looked at my file?
i did as you asked
I don't have slicers

[Anonymous]

null

[Ahmedx]

I get the quantity like this, show for the first week of February how much should be

[hashtag_pete]

Hello S, 

just to clarify your goal: if you have in week6 5 employees coming, one on each day, you would like to count them all for week 6, but if you drill up to the month, they should be 2 in January and 3 in February?

Best 

hashtag_pete