Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

null

7 Replies

  • 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

    • Anonymous's avatar
      Anonymous
      Not applicable

      null

      • Ahmedx's avatar
        Ahmedx
        Super User

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

  • 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