Forum Discussion
null
7 Replies
- hashtag_peteHelper V
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
- AhmedxSuper User
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 MonthBased 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- AnonymousNot applicable
null
- AhmedxSuper User
have you looked at my file?
i did as you asked
I don't have slicers
- hashtag_peteHelper V
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:
If this helps, please accept as solution and give kudos.
Best
hashtag_pete